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

Nodes with Problems view - plant a tree in there

Hi Guys,

I am after a way to show the Nodes we have problems with using a tree structure.

Currently I use a "All Nodes - Tree" view, structured using 3 custom properties fields and with a filter of "Status<>1 AND Unmanaged=0 AND Status<>11"

This allows me to view our down nodes in a tree structure (more specifically those that are not up, not unmanaged and not external). Because I am using STATUS<>1 this view excludes any nodes that are up unfortunately it also excludes those that are up but have interfaces that are down. Which are the ones I am trying to include.

Now I know I can use the "Nodes with Problems" view and this will list all our devices with issues including if the node only has 1 down interface but my problem is this list can be very larage and because it is not structured is very confusing as many devices on different sites have the same/similar names.

In short - does anyone know how to structure the "Nodes with Problems" view or is there a STATUS or tag a node takes when one of its interfaces is down, if there is I can add it into the filter I have.

Thanks.

Find more posts tagged with

Accepted answers

sedmo

The status field is numeric so try using Volumes.Status = 0 I don't currently have any volumes with an unknown status so I can't verify that 0 is the correct value for unknown but that is the value used for node status.

All comments

sedmo

I think you could use something like this.

statusdescription like '%Down%' AND Unmanaged=0 and Status <>11

tonyreel

Awesome, You are correct sedmo - although its * and not %

I have used the follow so as to also include anything that is Unknown as well.

StatusDescription Like '*Down*' OR StatusDescription Like '*Unknown*' AND UNMANAGED=0 AND Status<>11

Thank-you.

You don't happen to have a solution to putting the alerts into a tree structure? This is another list that gets too long and unstructured to be useful.

In fact surely the Node grouping functionality could be added to most of the views without too much effort would make life a lot easier for the bigger environments - NPM 10.2 perhaps

sedmo

Yep, * or % should work. the app will turn your * into a % before it executes the sql query.

The only way I can think of to put the alerts in a tree structure would be to write a custom asp page.

tonyreel

Would love to have the time to do a custom asp page but it would take me too long I'm afraid.

Maybe you could help me one last time on a similar topic. In the All Volumes view I am trying to dop another filter which I thought would have been very straightforward. I want to display all the volumes that have a status of Unknown.

I thought it would have been a case of Status = 'Unknown' or Volume.Status = 'Unknown' but everything I put in I keep getting the error "Custom SQL filter is incorrectly formated."

Some of the other properties work no problem i.e VolumePercentUsed > 95 works with no issues so I think I am being stupid but I can't think what I am doing wrong. Any ideas?