There is no need to get this data from the SQL db.
You can get that information with PowerCLI (except for the graphical elements in there).
In fact you could get the graphical elements but that would require using WPF or something similar.
The information on that page via a script
$report = @()
Get-VM | %{
$row = "" | Select Name, State, Status,Host,"Provisioned Space","Used Space","Host CPU - MHz",
"Host Mem - MB","Guest Mem - %",Notes,"Alarm Actions"
$_ | Get-Annotation | %{
$row | Add-Member -Name $_.Name -Value $_.Value -MemberType NoteProperty
}
$vm = $_ | Get-View
$row.Name = $_.Name
$row.State = $_.PowerState
$row.Status = $vm.Summary.OverallStatus
$row.Host = $_.Host.Name
$row."Provisioned Space" = ("{0:N2}" -f (($vm.Summary.Storage.Committed + $vm.Summary.Storage.Uncommitted) / 1GB)) + " GB"
$row."Used Space" = ("{0:N2}" -f ($vm.Summary.Storage.Committed / 1GB)) + " GB"
$row."Host CPU - MHz" = $vm.Summary.QuickStats.OverallCpuUsage
$row."Host Mem - MB" = $vm.Summary.QuickStats.HostMemoryUsage
$row."Guest Mem - %" = "{0:P0}" -f ($vm.Summary.QuickStats.GuestMemoryUsage / $vm.Summary.Config.MemorySizeMB)
$row.Notes = $_.Description
$row."Alarm Actions" = &{if($vm.AlarmActionsEnabled){"Enabled"} else{"Disabled"}}
$report += $row
}
$report | ft -AutoSize -Force
____________
Blog: LucD notes
Twitter: lucd22