If you have ever needed to find out which addresses have been allocated from System Center VMM managed IP address pools, it’s possible to do it in one line of PowerShell:
Get-SCIPAddress | Where {$_.State -eq “Assigned”} | Select Description, Address, AllocatingAddressPool | sort -Property AllocatingAddressPool
If you need to export this to CSV to let your networking team know what’s going on, it’s as simple as strapping an Export-CSV to the tail of the pipeline:
Get-SCIPAddress | Where {$_.State -eq “Assigned”} | Select Description, Address, AllocatingAddressPool | sort -Property AllocatingAddressPool | Export-CSV -NoTypeInformation
Leave a Reply