PowerCLI script to query a multiple network subnets

Here's a script that has a line multiplied 8 times, each to reflect the subnet it's querying and then outputting the results to a specific CSV file with the network subnet it just queried.



get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.6.*"} | export-csv -path c:\tmp\vmware\VM_IP_6_Addresses.csv -notypeinformation


get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.7.*"} | export-csv -path c:\tmp\vmware\VM_IP_7_Addresses.csv -notypeinformation


get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.8.*"} | export-csv -path c:\tmp\vmware\VM_IP_8_Addresses.csv -notypeinformation


get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.10.*"} | export-csv -path c:\tmp\vmware\VM_IP_10_Addresses.csv -notypeinformation


get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.11.*"} | export-csv -path c:\tmp\vmware\VM_IP_11_Addresses.csv -notypeinformation


get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.12.*"} | export-csv -path c:\tmp\vmware\VM_IP_12_Addresses.csv -notypeinformation


get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.13.*"} | export-csv -path c:\tmp\vmware\VM_IP_13_Addresses.csv -notypeinformation


get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.14.*"} | export-csv -path c:\tmp\vmware\VM_IP_14_Addresses.csv -notypeinformation


get-vm | select Name,@{N="IPAddress";E={@($_.guest.IPAddress[0])}},@{N="OS";E={@($_.Guest.OSFullName)}} | where {$_.IPAddress -like "192.168.15.*"} | export-csv -path c:\tmp\vmware\VM_IP_15_Addresses.csv -notypeinformation