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

Querying stale interfaces and excluding a specific vendor

wlouisharris2000

1) We had to turn off "delete stale interfaces" option in polling settings. We found that Juniper devices have standby pairs that we need to keep that were getting flagged as "stale"

2) We found this SWQL query to identify stale interfaces:

SELECT I.InterfaceName, N.Caption, N.DetailsURL AS [_LinkFor_Caption]
FROM Orion.NPM.Interfaces I INNER JOIN Orion.Nodes N ON (N.NodeID = I.NodeID)
WHERE I.Status = 0

3) We want to write a query to identify all Orion.Nodes NOT LIKE Juniper. Can someone help me with this query?

I tried something like this but the syntax is wrong:

SELECT I.InterfaceName, N.Caption, N.DetailsURL AS [_LinkFor_Caption]
FROM Orion.NPM.Interfaces I INNER JOIN Orion.Nodes N ON (N.NodeID = I.NodeID)
WHERE I.Status = 0
AND Orion.Nodes.Vendor NOT LIKE '%Juniper%'

Find more posts tagged with

Accepted answers

All comments

dodo123

What is the error

KMSigma.SWI

This is the syntax:

SELECT [Interfaces].Node.Caption AS [NodeName]
     , [Interfaces].Node.DetailsUrl AS [_LinkFor_NodeName]
     , [Interfaces].Node.Vendor
     , [Interfaces].InterfaceName
     , [Interfaces].DetailsUrl AS [_LinkFor_InterfaceName]
FROM Orion.NPM.Interfaces AS [Interfaces]
WHERE [Interfaces].Status = 0
  AND [Interfaces].Node.Vendor LIKE '%Windows%'

Just swap out Windows for Juniper.

This uses navigation properties instead of JOINs - I find them easier to understand. I covered some of this in my Using the API session at this year's THWACKcamp.