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");
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
