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

i want to add location on Volume Used chart on modern dashboard

sadiqsul

Find more posts tagged with

Accepted answers

All comments

dodo123

Please supply the swql from the edit of that widget so we can see what is being used

sadiqsul

SELECT
v.Node.Caption as NodeName,
v.DisplayName as VolumeName,
CASE
WHEN v.Size >= 1099511627776 THEN CONCAT(ROUND(v.Size/1099511627776,2), ' TB')
WHEN v.Size >= 1073741824 THEN CONCAT(ROUND(v.Size/1073741824,2), ' GB')
WHEN v.Size >= 1048576 THEN CONCAT(ROUND(v.Size/1048576,2),' MB')
WHEN v.Size >= 1024 THEN CONCAT(ROUND(v.Size/1024,2),' KB')
ELSE '0'
END as VolumeSize,
CASE
WHEN v.VolumeSpaceAvailable >= 1099511627776 THEN CONCAT(ROUND(v.VolumeSpaceAvailable/1099511627776,2), ' TB')
WHEN v.VolumeSpaceAvailable >= 1073741824 THEN CONCAT(ROUND(v.VolumeSpaceAvailable/1073741824,2), ' GB')
WHEN v.VolumeSpaceAvailable >= 1048576 THEN CONCAT(ROUND(v.VolumeSpaceAvailable/1048576,2),' MB')
WHEN v.VolumeSpaceAvailable >= 1024 THEN CONCAT(ROUND(v.VolumeSpaceAvailable/1024,2),' KB')
ELSE '0'
END as SpaceAvailable,
ROUND(VolumePercentUsed,1) as PercentUsed,
v.Node.DetailsUrl as LinkForNode,
v.DetailsUrl as LinkForVolume,
v.volumeType as Volumetypeka
FROM Orion.Volumes as v
where Volumetypeka = 'fixed disk'
ORDER BY VolumePercentUsed DESC

sadiqsul

here it is

sadiqsul

HERE IT IS