Had a fellow MVP (nickzourdos) ping out looking to create a resource that showed the Top 10 Volumes by Percent Utilization, but only for Virtual Machines. Unfortunately, due to the nature of VMs coming up and down, a standard custom property just wasn't dynamic enough for his needs.
This SWQL query can be placed in a Custom Query Resource on any summary page in Orion to do the trick.
SELECT TOP 10 --Or however many you want here...
v.Node.Caption AS [DEVICE NAME]
,v.Node.WebUri.WebUri AS [_LinkFor_DEVICE NAME]
,'/Orion/images/StatusIcons/Small-' + v.Node.StatusLED AS [_IconFor_DEVICE NAME]
,v.Caption AS [VOLUME NAME]
,v.WebUri.WebUri AS [_LinkFor_VOLUME NAME]
,'/Orion/images/StatusIcons/Small-' + v.StatusLED AS [_IconFor_VOLUME NAME]
,TOSTRING(ROUND(v.VolumePercentUsed,2)) + '%' AS [PERCENT UTILIZATION ROUNDED] --This column rounds the data, so you'll see things like 99.99% turn into 100%
,SUBSTRING(TOSTRING(v.VolumePercentUsed),0,6) + '%' AS [PERCENT UTILIZATION TRUNCATED] --This column sets the data to a string and then truncates to 6 digits, so you'll get slightly more accurate results if needed
FROM Orion.Volumes v
WHERE v.Node.VirtualMachine.NodeID IS NOT NULL --Only return VMs
AND v.VolumeTypeID IN (
4 --FixedDisk
,10 --NetworkDisk
,100 --MountPoint
)
ORDER BY v.VolumePercentUsed DESC
Enjoy: 