Hi,
I would like to create a modern dashboard with a table widget to see my volumes usage.
I didn't manage to see the available space in a "Humain" units. We just can see the space in bytes.
How to see/convert the different bytes values in a MB or GB units automatically?
Thanks
I haven't been able to find an automatic way but this is what I did in order to convert the data. You would need to select the Hand-Edit SWQL option and use this Query:
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
FROM Orion.Volumes AS v
ORDER BY VolumePercentUsed DESC
Format the columns like so:
Column 1
Column 2
Column 3
Column 4
Column 5
Will look like this in the end:
