Thank you for quick reply !
I need monthly total for each VM. It looks like this:
VM-name | CPU | Uptime | Memory total | Memory avg | HDD size | HDD Datastore
a1 2 156h 12GB 9.7GB Disk1 60GB a1_demo/dd.vmdk
Disk1 80GB a2_demo/dd.vmdk
a2 ...
My current script (faulty) looks like this:
$VmInfo = ForEach ($Datacenter in (Get-Datacenter | Sort-Object -Property Name)) {
ForEach ($Cluster in ($Datacenter | Get-Cluster | Sort-Object -Property Name)) {
ForEach ($VM in ($Cluster | Get-VM | Sort-Object -Property Name)) {
ForEach ($HardDisk in ($VM | Get-HardDisk | Sort-Object -Property Name )) {
$SnapSize=Get-Snapshot -VM $VM | Measure-Object -Property SizeGB -Sum
"" | Select-Object -Property @{N="VM";E={$VM.Name}},
@{N="Datacenter";E={$Datacenter.name}},
@{N="Folder";E={$VM.Folder}},
@{N="Host";E={$VM.VMHost}},
@{N="Cluster";E={$Cluster.Name}},
@{N="# CPU";E={$VM.NumCpu}},
@{N="Uptime";E={(new-timespan $_.ExtensionData.Summary.Runtime.BootTime $end).days}},
@{N="MemoryUsageGB"; E={[Math]::Round($_.MemoryUsageGB, 3)}}, @{N="MemoryTotalGB"; E={[Math]::Round($_.MemoryTotalGB, 3)}},
@{N="MemoryUsage%"; E={"{0:P0}" -f [Math]::Round($_.MemoryUsageGB/$_.MemoryTotalGB, 3)}},
@{N="RAM";E={$VM.MemoryGB}},
@{N="IP";E={$VM.Guest.IPAddress}},
@{N="Hard Disk";E={$HardDisk.Name}},
@{N="HD Size";E={$HardDisk.CapacityGB}},
@{N="HD Type";E={$HardDisk.StorageFormat}},
@{N="Snap Size";E={$SnapSize.Sum}},
@{N="VMDK Size";E={($vm.extensiondata.layoutex.file|?{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB}},
@{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},
@{N="VMDKpath";E={$HardDisk.FileName.Split("]")[1]}}
}
}
}
}$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "C:\file"
