Hi:
Please, is there any way to create a Top 10 Volumes by Disk Space Used ,
to show only hard drives and swap ?
I don´t want to see physical memory .
Should be able to click edit on the top 10 resource and specify an advanced sql filter to only show the items you care about
Ok, but where I´ll put the SQL command ?
So if you Orion account has edit resources permission, if you go to the top 10 and for the existing top 10 volume utilization for example on the upper right corner of that resource you should see an edit button. Click this and in this new screen at the bottom you will see where you can enter this filter and also example of how to filter
Thanks a lot !
it's not a TOP 10 view but here's a report you might like to publish into Orion. those with NODES.REGION will need to be adjusted to your site's Custom Node Properties.
it shows all Windows servers with 10% to 0% available disk space remaining (it doesn't include swap for this particular report).
SELECT Nodes.DNS AS DNS, Nodes.IP_Address AS IP_Address, Nodes.Department AS Department, Volumes.VolumeDescription AS Volume_Description, (NullIf(VolumeSize,-2)-NullIf(VolumeSpaceUsed,-2)) AS VolumeSpaceAvailable, 100-NullIf(VolumePercentUsed,-2) AS VolumePercentAvailable, Volumes.VolumeSize AS Volume_Size FROM Nodes INNER JOIN Volumes ON (Nodes.NodeID = Volumes.NodeID) WHERE ( (Nodes.Region LIKE 'hq%') AND ( (Volumes.VolumeType = 'fixed disk') AND (Nodes.Vendor LIKE '%windows%') AND (100-NullIf(VolumePercentUsed,-2) <= 10)) AND ( NOT (Nodes.Caption LIKE '%test%') AND NOT (Nodes.Caption LIKE 'hq-hot%') AND NOT (Nodes.Caption LIKE 'hq-hoca%')))
ORDER BY 6 ASC
