Interface Down report

Since you have the 'NodesOLD' table, I am going to assume that you are on NPM 11.5.

If that's the case, you could make this easier with the web report writer GUI by selecting all interfaces with Status = Down

The trick is to know that interfaces are inherently dependent on their parent nodes. Meaning that if a node goes down, the interfaces go into an 'Unreachable' status (not down). It is not possible with the current version to have a down interface on a down node. (unless there is a bug I am unaware of )

That being said, if you want to proceed with SQL, the next thing to learn is that the NodesOLD table is no longer in use. For your reference, the Nodes table was split into 3 distinct tables, NodesData, NodesStatistics, and NodesCustomProperties. To retain functionality with older queries, SolarWinds was kind enough to create a new view called 'Nodes' that has all of the details from NodesOLD.

tl;dr - You can still use 'Nodes' to reference whatever you need for your reports.

As seen here, whether I look for only down interfaces, or only down interfaces with nodes that are not down; I still get 81 results.

And finally, regarding your errors; the ambiguos name error is because the NodeID field exists in both the Interfaces and NodesOLD tables. So you have to tell your query which one you care about. The multi part could not be bound error is similarly because you didn't give a table name to the 'Status' part of the SELECT statement.

Ambiguous = You didn't give ANY table names for duplicate column names.

Multi Part... = You gave table names for some, but not ALL duplicate column names.

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

Thanks for the info Zach... yes we are on the newer version of NPM... I guess I did not put together the idea of an interface being unreachable if a node is down but it makes sense... got the SQL working with a little help from a DBA...