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

Nodes organized by Group in Group Details?

Hello. I want my "Top XX Nodes" resources in Group Details view to show only those nodes in that group. For instance, only nodes from Group A in the respective page, Group B in the respective page, and so on.

I thought I could use a custom property for this, but the SQL filter applies across all groups - not just one. So using something like "Group_ = 'GroupA;' " causes all Group Details panes to show only Group A. I have experimented with View Limitations but I seem to run into basically the same issue; whichever limitation I choose applies across all groups, not just the ones I want.

Any suggestions?

Find more posts tagged with

sql filters

group details view limitation variable*

Accepted answers

All comments

mprobus

I'm not sure I'm following when you say the filter applies across all of the groups. Do you mean you filter on 1 Top XX and the filter applies to them all? Can you post a screenshot of what you are seeing?

mrtickles

Thanks for the reply!

Let's say I have Groups A, B, and C. When I currently go to the Group Details page for any of the three groups, the Top XX tool shows nodes from all of the groups. If I look at the Group Details page for Group A, the Top XX tool shows nodes from A, B, and C. There is no filtering.

I created the Custom Property "Group_" and applied it to all the nodes in Group A, to start out with. I then used SQL filter command "Group_ = 'Group A' " in the Edit Resource screen for Top XX while in the Group A Details page.

It worked, but a little too well. This seems to apply to every Top XX tool in every group - so even in the Details pages for Groups B and C, only nodes for Group A are shown in Top XX. What I want is for the Group A details page to show only Top XX nodes in Group A, and so on for the other groups. I don't want a SQL filter to apply across all Top XX tools for each group, I want individual SQL filters for individual groups.

If that doesn't make sense, I'll provide screenshots.

mprobus

I'm with you know.

The problem is due to the fact that by going into the Group Details and editing it, you are actually editing the Group Details View and not just that specific group. So, any changes you make are propagated across anything that uses that view.

My suggestion would be to create a TopXX page and do your filtering in there. You can filter each individual resource at that level.