cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Modern Dashboard for Volumes

Jump to solution

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

Sidel-it_0-1606921005794.png

 

Labels (2)
Tags (2)
1 Solution
Level 8

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

  • Description: Server
  • Format: Orion Entity
  • Icon: No Icon
  • DetailsUrl: LinkForNode
  • Label: NodeName

Column 2

  • Description: Volume
  • Format: Orion Entity
  • Icon: No Icon
  • DetailsUrl: LinkForVolume
  • Label: VolumeName

Column 3

  • Description: Size
  • Format: No Formatter
  • Value: VolumeSize

Column 4

  • Description: Available Space
  • Format: No Formatter
  • Value: SpaceAvailable

Column 5

  • Description: % Used
  • Format: Threshold Value
  • Visualization: Add a linear bar chart
  • Value: PercentUsed
  • Thresholds Percent Disk Space Used (Volume)

Will look like this in the end:

1.png

View solution in original post

5 Replies
Level 8

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

  • Description: Server
  • Format: Orion Entity
  • Icon: No Icon
  • DetailsUrl: LinkForNode
  • Label: NodeName

Column 2

  • Description: Volume
  • Format: Orion Entity
  • Icon: No Icon
  • DetailsUrl: LinkForVolume
  • Label: VolumeName

Column 3

  • Description: Size
  • Format: No Formatter
  • Value: VolumeSize

Column 4

  • Description: Available Space
  • Format: No Formatter
  • Value: SpaceAvailable

Column 5

  • Description: % Used
  • Format: Threshold Value
  • Visualization: Add a linear bar chart
  • Value: PercentUsed
  • Thresholds Percent Disk Space Used (Volume)

Will look like this in the end:

1.png

View solution in original post

Hello,

How would you filter this to show only fixed disks?

0 Kudos

Thanks a lot 👍👍👍👍🙏

Good job.

0 Kudos

Question, where are you using this view?

0 Kudos

In Modern Dashboard 😉

0 Kudos