CodeShare
Have some code. Share some code.
cancel
Showing results for 
Search instead for 
Did you mean: 
cjunior
Nacreous
Nacreous

Problem this snippet solves:

Exports BIGIP LTM to Excel

How to use this snippet:

0151T000003d9D2QAI.PNG

0151T000003d9D3QAI.PNG

Code :

46328

Tested this on version:

11.5
Comments
tom3020
Nimbostratus
Nimbostratus
Thank you very much! I'm from Europe and we have some partitions. I changed: $Excel = New-Object -ComObject Excel.Application; ===> [threading.thread]::CurrentThread.CurrentCulture = 'en-US' $Excel = New-Object -ComObject Excel.Application; ===AND=== $vs_address_name = $vs.destination.Split(":")[0].Replace("/", "~"); ===> $vs_address_name = ($vs.destination.Split(":")[0].Replace("/", "~")).Replace("%","%25");
cjunior
Nacreous
Nacreous
please feel free, many thanks!
Julio_Navarro
Cirrostratus
Cirrostratus
Hi cjunior! Great Script! One detail: on the Pool Tab/Plus members (second sheet), It only showed one member, not all the members. Any idea? Thank J
Julio_Navarro
Cirrostratus
Cirrostratus
I made the following change: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ foreach ($pool in $pool_list.items) { Write-Verbose "Pool: $pool"; $members = Invoke-Get "/ltm/pool/$($pool.fullPath.Replace('/', '~'))/members/?`$select=fullPath, items"; for($i=0; $i -lt $members.items.count; $i++) { $member = $members.items[$i]; $WorkSheet.Cells.Item($row, $colPool_Name) = $pool.fullPath; $WorkSheet.Cells.Item($row, $colPool_Member) = $member.fullPath; $WorkSheet.Cells.Item($row, $colPool_LBMethod) = $pool.loadBalancingMode; $WorkSheet.Cells.Item($row, $colPool_Monitor) = $pool.monitor; Write-Host $member.fullPath; $row++; } Write-Host "." -NoNewline; } ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ This way if I have a pool with more than one member, for example - 3 members, i will have three records Pool - member1 Pool - member2 Pool - member3 :-) J
cjunior
Nacreous
Nacreous
No problem J., Sorry my mistakes. I need to improve more functionalities to this script too. Thanks in advance.
Version history
Last update:
‎14-May-2015 12:21
Updated by:
Contributors