Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Custom Volume Report with Disk Space Used Image

I wish to create a dashboard showing the following:

All Volumes from X number of servers

I wish to use the custom query widget so that I can show some Icons. In particular I want to show the disk used bar as shown on the Node Disk Volumes Widget i.e.

The query I am running is the following:

SELECT n.caption as [Node]

, v.Caption as [Volume]

, round(v.VolumePercentUsed,1) as [Space Used]

,round(v.volumespaceavailable/1073741824,1) as [Free GB]

,case when f.DaysToCapacityPeak is null then 'No Forecast'

when f.DaysToCapacityPeak<0 then 'Full'

when f.DaysToCapacityPeak<91 then tostring(f.DaysToCapacityPeak)

when f.DaysToCapacityPeak>90 then '>90 Days'

end as [Days til Full],

v.DetailsUrl as [_linkfor_Volume]

, n.DetailsUrl as [_linkfor_Node]

,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node]

, case when fc.WarningThreshold is null and v.VolumePercentUsed > (Select CurrentValue AS [col1] FROM Orion.Settings WHERE SettingID = 'NetPerfMon-DiskSpace-Error') then '/Orion/images/StatusIcons/Small-Critical.gif'

when fc.WarningThreshold is null and v.VolumePercentUsed > (Select CurrentValue AS [col1] FROM Orion.Settings WHERE SettingID = 'NetPerfMon-DiskSpace-Warning') then '/Orion/images/StatusIcons/Small-Warning.gif'

when v.VolumePercentUsed>f.CriticalThreshold then '/Orion/images/StatusIcons/Small-Critical.gif'

when v.VolumePercentUsed>f.WarningThreshold then '/Orion/images/StatusIcons/Small-Warning.gif'

end as [_Iconfor_Space Used]

,'/Orion/images/StatusIcons/Small-' + v.StatusIcon AS [_IconFor_Volume]

from orion.Volumes v

join orion.nodes n on n.nodeid=v.nodeid

left join Orion.ForecastCapacitySettings fc on fc.InstanceId=v.VolumeID and fc.metricid=3

left join Orion.ForecastCapacity f on f.InstanceId = v.VolumeID and f.EntityType='Orion.volumes'

left join Orion.AlertSuppression asup on asup.entityuri = n.uri

where v.FullName like 'myserver%' and v.Type in ('Fixed Disk','Mountpoint')

order by currentvalue desc

Find more posts tagged with

Accepted answers

All comments

dunky2k

We have something like this, is this what your looking for?

shocko

Yes please! Can you post the SWQL query ?

dunky2k

Below is the query that we use, if you need help with the column setup let me know.

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

tcox8

Is this in a report? If not, can it be made that way? I have been looking for a way to add a graphical representation of disk space usage to our report. I attempted to us the SWQL query you posted below but it does not show the graphics like you have in your picture.

christopher.t.jones123

@tcox8, it looks like he created this as a modern dashboard. to make it a report might be a little tricky I don't have a test instance at the moment, but when I get my hands on one I can try and play around with it and post back to here.