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
Store

Help with displaying Volume information on the Groups page in NPM

First off I have a case open (# 1085146) but I haven't had a chance to work with support yet. I'm usually able to figure it out on my own or here on Thwack

In a previous post Can I get group nodes' CPU load charts into one view? another Thwack user (thanks mesverrum!) showed me how to set up Groups to display CPU information for a large group of servers

using a function I had previously overlooked - "AUTOMATICALLY DISPLAY (Metric) RELATED TO THE CURRENT VIEW"

Since I had been creating dashboards displaying CPU, Memory, Disk, etc manually for a lot of my server farms I was pretty excited about using this feature!!!

I should be able to create one Group Dashboard and then just create a bunch of groups and presto! I have all my dashboards done in a jiffy ..... but now I have run into a snag.

I can't display Volume information using this method

Is it just my install or is it a future feature request? Can someone give it a try and see if it works in your environment?

I started on my Home Menu and then Groups

Created a group and added some nodes that were already collecting snmp information for CPU, Memory, and the C drive.

Then I opened the Group Details page for that group and went to 'Customize Page' on the top right.

Add a Multiple Object Chart to one of the columns

Mine is in Column 5

Preview the chart

Edit the chart you just added

Select Volumes and Automatically display volumes related to the current view then Submit it

(I left it at the default - Percent Disk Usage)

I am getting this

If I manually change it to 'Select specific volumes' and manually add some volumes from that Group it works.

Manually selected - it works, so I know the data is being collected from the node

The other charts for other metrics for this group work fine. CPU Load, Percent Memory Used, and Average Response Time - but not Volumes.

Any ideas?

Find more posts tagged with

groups

Accepted answers

mesverrum

Seeing your screenshot made me think of a possible issue the we would want to script around. If there are more than 10 volumes in the group then the initial query will only display so many and we might miss things on the volumes that didn't make the cut, so you can use this variant of the query to display the top 10 volumes based on their current disk utilization instead of seeing whatever random volumes it picked first.

select v.FullName + ' - ' + tostring(v.VolumePercentUsed) + '%' as Label, v.VolumeUsageHistory.PercentDiskUsed, v.VolumeUsageHistory.DateTime

from orion.volumes v

where v.VolumeID in

(SELECT top 10 v.VolumeID

FROM Orion.ContainerMembers cm

join orion.Volumes v on v.nodeid=cm.MemberPrimaryID

where memberentitytype = 'Orion.Nodes' and containerid= ${id}

order by v.VolumePercentUsed desc)

All comments

bobmarley

2019 - Bump. This is a basic feature and it's broken. Please fix it

mesverrum

Looked into this, the multiple object chart does actually work if you add the volumes themselves as members of the group, but doing that is clunky and too much work.

So I wrote a custom swql query that you can use in the Custom Chart tool that works much better. Don't need to add the volumes to the group, it will automatically find them if their parent node is in the group, plus it is more visually appealing and you can use the mouseover tooltip to see the actual value for any specific timestamp.

Add a Custom Chart, set the data source to custom SWQL, paste this in

select v.FullName + ' - ' + tostring(v.VolumePercentUsed) + '%' as Label, v.VolumeUsageHistory.PercentDiskUsed, v.VolumeUsageHistory.DateTime

from orion.volumes v

where v.nodeid in

(SELECT MemberPrimaryID

FROM Orion.ContainerMembers cm

where memberentitytype = 'Orion.Nodes' and containerid= ${id}) --that last bit is how it knows to use the container we are looking at

Set up all the options like so

bobmarley

Thanks!

Getting an error when trying to run it in SWQL Studio. Any suggestions?

mesverrum

Yeah, it won't be able to run in SWQL studio unless you replace the ${id} variable with a real group id from your environment. Inside the GUI it will pull the ID from whatever group you happen to be looking at.