nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
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

karunakar.enugula

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.

chad.every

I would recommend downloading and installing the OrionSDK "SWQL Studio" tool if you have not already.

Releases · solarwinds/OrionSDK (github.com)

It would allow you to see all of the entities and what properties are available to add. That way you could see if there was a DateTime property available in the entity you're using.