I expect my script to just be a report reading the information I am looking for.
I would like this to be in a csv file and this data is not going to be imported anywhere.
I understand there can be many NIC's, Datastores, and IP's and I think that is where I am struggling to get the data. Can you help with that? Here is my most recent edit of the script - I am not sure if it is as efficient as it could be as well. I am able to pull all my data besides the datastores or harddisk, I am also not getting the IP's or OS for all the VM's but some of them - which seems odd. Thanks
filter Get-FolderPath {
$_ | Get-View | % {
$row = "" | select Name, Path
$row.Name = $_.Name
$current = Get-View $_.Parent
# $path = $_.Name # Uncomment out this line if you do want the VM Name to appear at the end of the path
$path = ""
do {
$parent = $current
if($parent.Name -ne "vm"){$path = $parent.Name + "\" + $path}
$current = Get-View $current.Parent
} while ($current.Parent -ne $null)
$row.Path = $path
$row
}
}
$ExportFilePath = "z:\VMInfo.csv"
$Report = @()
$VMs = Get-VM vmname
$adapters =Get-NetworkAdapter $VMs | select Name,Type,NetworkName
$Datastores = Get-Datastore | select Name, Id
$harddisk =Get-harddisk $VMs| select Name, Parent, StorageFormat, FileName, CapacityGB
$VMHosts = Get-VMHost | select Name, Parent
ForEach ($VM in $VMs) {
$VMView = $VM | Get-View
$VMInfo = {} | Select
VMName,OS,IPAddress,NetworkAdapter,NICType,VLAN,Host,Datacenter,Cluster,Disk,DatastoreName,Format,Capacity,NumCPU,MemMb
,Notes
$VMInfo.VMName = $vm.name
$VMInfo.OS = $vm.Guest.OSFullName
$VMInfo.IPAddress = $vm.guest.IPAddress[0]
$VMInfo.NetworkAdapter = ($vm| get-networkadapter).Name
$VMInfo.NICType = ($vm | get-networkadapter).type
$VMInfo.VLAN = ($vm | get-networkadapter).Networkname
$VMInfo.Host = $vm.host.name
$VMInfo.Datacenter = ($vm | Get-Folderpath).Path
$VMInfo.Cluster = $vm.host.Parent.Name
$VMInfo.Disk = ($harddisk | ).Name
$VMInfo.DatastoreName = ($vm | get-harddisk).FileName
$VMInfo.Format = ($vm | get-harddisk).storageformat
$VMInfo.Capacity = ($vm | get-harddisk).capacityGB
$VMInfo.NumCPU = $vm.NumCPU
$VMInfo.MemMb = [Math]::Round(($vm.MemoryMB),2)
$VMInfo.notes = $vm.notes
$Report += $VMInfo
}
$Report = $Report | Sort-Object VMName
IF ($Report -ne "") {
$report | Export-Csv $ExportFilePath -NoTypeInformation
}
