This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Top XX Volumes by Percent Utilization - Virtual Machines

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: emoticons_happy.png