BIGIP Inventory - iControl REST

Problem this snippet solves:

Exports BIGIP LTM to Excel

How to use this snippet:

Code :

46328

Tested this on version:

11.5
Published May 14, 2015
Version 1.0

Was this article helpful?

5 Comments

  • 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");
  • 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
  • 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
  • No problem J., Sorry my mistakes. I need to improve more functionalities to this script too. Thanks in advance.