Version 2

    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