Install-Module ImportExcel -Force # Then replace Export-Csv with Export-Excel for formatted Excel workbooks with multiple sheets : If you need a GUI tool, HVReports is your best bet. For maximum flexibility and zero cost, use the PowerShell script above which provides all the core features RVTools offers for VMware.
# Hyper-V Inventory Report - Full Feature # Run as Administrator on Hyper-V host or with Hyper-V module $ReportPath = "C:\HyperVReports" New-Item -ItemType Directory -Force -Path $ReportPath $HostInfo = Get-VMHost | Select-Object Name, @N="Processors";E=$ .LogicalProcessors, @N="MemoryGB";E=[math]::Round($ .MemoryCapacity/1GB,2), Version, BuildNumber 2. VM Inventory $VMInfo = Get-VM | Select-Object Name, State, @N="CPUCount";E=$ .ProcessorCount, @N="MemoryGB";E=[math]::Round($ .MemoryMinimum/1GB,2), @N="DiskGB";E=[math]::Round((Get-VMHardDiskDrive $_ , Uptime, CreationTime 3. Network Configuration $NetworkInfo = Get-VMNetworkAdapter -All | Select-Object VMName, Name, MacAddress, SwitchName, IPAddresses, Status 4. Storage & VHDX $StorageInfo = Get-VMHardDiskDrive -All | Select-Object VMName, ControllerType, ControllerNumber, Path, @N="SizeGB";E=[math]::Round($_.MaximumSize/1GB,2) 5. Checkpoint (Snapshot) Info $CheckpointInfo = Get-VMSnapshot -All | Select-Object VMName, Name, SnapshotType, CreationTime, ParentSnapshotName 6. Replication Status (if configured) $ReplicationInfo = Get-VMReplication | Select-Object Name, ReplicationState, ReplicationHealth, PrimaryServer, ReplicaServer 7. Resource Metering (performance) Start-VMResourceMetering -All Start-Sleep -Seconds 30 $Performance = Measure-VM | Select-Object VMName, @N="AvgCPU";E=[math]::Round($ .AverageProcessorUsage,2), @N="AvgMemoryMB";E=[math]::Round($ .AverageMemoryUsage,2), @N="TotalDiskMBps";E=[math]::Round($_.TotalDiskThroughput,2) Export to CSV/HTML $HostInfo | Export-Csv "$ReportPath\Hosts.csv" -NoTypeInformation $VMInfo | Export-Csv "$ReportPath\VMs.csv" -NoTypeInformation $NetworkInfo | Export-Csv "$ReportPath\Networks.csv" -NoTypeInformation $StorageInfo | Export-Csv "$ReportPath\Storage.csv" -NoTypeInformation $CheckpointInfo | Export-Csv "$ReportPath\Checkpoints.csv" -NoTypeInformation $ReplicationInfo | Export-Csv "$ReportPath\Replication.csv" -NoTypeInformation $Performance | Export-Csv "$ReportPath\Performance.csv" -NoTypeInformation rvtools for hyper-v