Modern Dashboard diskspace table widgets

bthorne

Does anyone have any swql queries to query disk space that are useful ?

Top 40
Can show the correct %
Filter out vss,shared memory
Node name
anything to make it look good as well.

Current query:

SELECT TOP 40 n.Caption,
v.VolumePercentUsed,
CONCAT(ROUND(v.VolumePercentUsed,2), '% Used') AS [Volume Percentage Used],
v.VolumeType,
n.Caption AS [Server Name],
v.Uri
FROM Orion.Volumes v
JOIN Orion.Nodes n ON v.NodeId = n.NodeId
WHERE v.VolumeType IN ('Fixed Disk', 'FixedDisk', 'Mount Point')
ORDER BY v.VolumePercentUsed DESC

dunky2k

We use 2 modern dashboards that show us a donut of the status's and then a tabular table with the info we require.

Here are the swql queries that we use to achieve the above.

select Status, 
sum(StatusCounter) as StatusCount 
from (select Status, 
1 as StatusCounter from Orion.Volumes 
where DisplayName != 'Physical Memory' 
and DisplayName != 'Virtual Memory' 
and DisplayName like '%:\%') 
group by Status

select node.nodename, 
       vfc.DetailsURL,
       vfc.DisplayName,
       vol.VolumePercentUsed
  from Orion.Nodes as node,
       Orion.Settings as s,
       Orion.VolumesForecastCapacity as vfc,
       Orion.Volumes as vol
       where node.Unmanaged = false 
         and node.NodeID = vfc.NodeID
         and s.SettingID = 'ForecastMinDays'
         and vfc.MetricName = 'Forecast.Metric.PercentDiskUsed'
         and DayDiff(vfc.MinDateTime, vfc.MaxDateTime) >= isnull(s.CurrentValue, 7)
         and vfc.DisplayName != 'Physical Memory'
         and vfc.DisplayName != 'Virtual Memory'
         and vfc.DisplayName LIKE '%:\%'
         and vfc.Volume.VolumeID = vol.VolumeID
ORDER by vol.VolumePercentUsed DESC