Get-Datastore -PipelineVariable ds | Get-VM |
ForEach-Object -Process {
Write-Host "Looking at $($_.Name)"
$obj = [ordered]@{
VM = $_.Name
VMState = $_.ExtensionData.summary.runtime.powerState
Boottime = $_.ExtensionData.Runtime.BootTime
TotalNics = $_.ExtensionData.summary.config.numEthernetCards
Portgroup = Get-View -Id $_.ExtensionData.Network -Property Name | select -ExpandProperty Name
OS = $_.ExtensionData.Config.GuestFullName
Hostname = $_.ExtensionData.guest.hostname
IPAddress = $_.ExtensionData.guest.ipAddress
VMHost = Get-View -Id $_.ExtensionData.Runtime.Host -property Name | select -ExpandProperty Name
ProvisionedSpaceGB = [math]::Round(($_.ExtensionData.Summary.Storage.Committed + $vm.Summary.Storage.UnCommitted)/1GB,0)
TotalUsedSpaceGB = [math]::Round($_.ExtensionData.Summary.Storage.Committed/1GB,0)
MemoryReservation = $_.ExtensionData.resourceconfig.memoryallocation.reservation
CPUreservation = $_.ExtensionData.resourceconfig.cpuallocation.reservation
TotalCPU = $_.ExtensionData.summary.config.numcpu
TotalMemoryGB = [math]::Round($_.ExtensionData.summary.config.MemorysizeMB/1KB,0)
Memory = $_.ExtensionData.summary.config.memorysizemb
MemoryUsage = $_.ExtensionData.summary.quickStats.guestMemoryUsage
ToolsStatus = $_.ExtensionData.guest.toolsstatus
ToolsVersion = $_.ExtensionData.config.tools.toolsversion
TimeSync = $_.ExtensionData.Config.Tools.SyncTimeWithHost
HardwareVersion = $_.ExtensionData.config.Version
Datastore = $_.ExtensionData.Config.DatastoreUrl[0].Name
CBT = $_.ExtensionData.Config.ChangeTrackingEnabled
Notes = $_.ExtensionData.Config.Annotation.ToString()
FaultTolerance = $_.ExtensionData.Runtime.FaultToleranceState
SnapshotName = &{$script:snaps = Get-Snapshot -VM $_.ExtensionData.Name; $script:snaps.Name -join ","}
SnapshotDate = $script:snaps.Created -join ","
SnapshotSizeGB = $script:snaps.SizeGB -join ","
ToolsState = $_.Guest.State
GuestUsageGB = [math]::Round(($vm.Guest.Disks | %{$_.CapacityGB - $_.FreeSpaceGB} | Measure-Object -Sum | Select -ExpandProperty Sum),1)
GuestCapacityGB = [math]::Round(($_.Guest.Disks | %{ $_.Capacity / 1GB} | Measure-Object -Sum | Select -ExpandProperty Sum),2)
FreeSpaceGB = [math]::Round(($_.Guest.Disks | %{ $_.FreeSpace / 1GB} | Measure-Object -Sum | Select -ExpandProperty Sum),2)
'GuestUsage(%)' = &{
$capacityGB = $_.Guest.Disks | Measure-Object -Property CapacityGB -Sum | Select -ExpandProperty Sum
$freeGB = $_.Guest.Disks | Measure-Object -Property FreeSpaceGB -Sum | Select -ExpandProperty Sum
if($capacityGB){
[math]::Round((($capacityGB - $freeGB)/$capacityGB*100),2)
}
}
VMDKSizeGB = (Get-HardDisk -VM $_ | Measure-Object -Property CapacityGB -Sum).Sum
System_Group = (Get-TagAssignment -Category "System Group" -Entity $_).Tag.Name
System_Type = (Get-TagAssignment -Category "System Type" -Entity $_).Tag.Name
}
$diskNum = 1
if($_.Guest.Disks){
$_.Guest.Disks | ForEach-Object -Process {
$obj.Add("Disk$($DiskNum)_Path",$_.Path)
$obj.Add("Disk$($DiskNum)_Capacity(GB)",([math]::Round($_.CapacityGB,1)))
$obj.Add("Disk$($DiskNum)_FreeSpace(GB)",([math]::Round(($_.FreeSpaceGB),1)))
$obj.Add("Disk$($DiskNum)_USedSpace(GB)",([math]::Round($_.CapacityGB - $_.FreeSpaceGB,1)))
$obj.Add("Disk$($DiskNum)_USedSpace%",([math]::Round((1 - ($_.FreeSpace)/$_.Capacity)*100,1)))
$DiskNum++
}
}
New-Object PSObject -Property $obj
} | Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture
