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

NCM Custom SWQL Query

Hello Team, can someone advise me if it is possible to create a NCM Custom SWQL Query to tell me the NCM node status = " Up & warning Devices" in the report.

Find more posts tagged with

Accepted answers

adam.beedell

Certainly possible.
Usually NCM statuses would be like Job statsus, Compliance, etc. the Platform Core/Node status is probably what you want

SELECT whateverYouWant, n.caption, n.status
From Orion.nodes N
Where N.status in (2,3)

Or similar using the graphical editor

There's almost certainly a OOTB report along these lines to copy

All comments

adam.beedell

There's almost certainly a OOTB report along these lines to copy

karunakar.enugula

I am getting query not valid.

chad.every

replace the '=' with 'IN'

Orion.Status IN (2,3)

karunakar.enugula

Hi Chad,

I want to add date and time in same report, could you please help.