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

Need Help in Down Interface KPI ( Modern Dashboard )

Need help to put Interface Status =2 ( Down ) in following script to get only Down Interfaces

SELECT TOP 1000 InterfaceID, atm_interface, backhaul, Br_Media, BranchName, CarrierName, Comments, Core_Interfaces, Interface_contains, newitnerface, PrimaryMedia, Remarks
FROM Orion.NPM.InterfacesCustomProperties

WHERE ( Comments = 'SD Interfaces' )

Find more posts tagged with

Comments

stuartd

We don't have any atm interfaces here so can't directly advise. In looking at our version of'Orion.NPM.InterfacesCustomProperties' I don't see that field so my question is: from what table are you wanting to get the status?

However, if it's just the basic syntax you need then - WHERE Status = '2' - should do the trick, so long as 'status' is a valid filed in the table you are currently querying, otherwise you'll have to do a JOIN first.

makecrazy

atm_interface is interface custom property