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

Custom SWQL Query help

So I'm needing to create a query to give a list of all down nodes but not unmanned ones ...with a couple of custom fields .... here's what I have so far.... any help would be appreciated.

SELECT StatusLED, NodeName,

Nodes.CustomProperties.Alert_Team, Nodes.CustomProperties.Environment

FROM Orion.Nodes WHERE Status <>1

Find more posts tagged with

Accepted answers

All comments

ecklerwr1

Perhaps you should ask in the SDK forum:

tdanner is the man when it comes to this :^}

mr.e

Please try the following query against the name of your Orion database:

SELECT StatusLED, Caption, Alert_Team, Alert_Team, Environment

FROM Nodes WHERE Status = 2 and

Unmanaged <> 1

jkirschn

That worked great, a couple more questions how do I get the node name as a link so the user can click the node name and get a deeper view of the node? also how do I get the red bubble rather than the "Down.gif" file name.... here is what I see below...... sorry for the question .. a bit new to SolarWinds.

mr.e

Easy, a small modification needed to the SQL script:

SELECT NodeID, StatusLED, Caption, Alert_Team, Alert_Team, Environment

FROM Nodes WHERE Status = 2 and

Unmanaged <> 1

Once you add the NodeID field to your report, it will automatically give you the link on your reports.

jkirschn

Cool, so any thoughts on the "Status LED" Bubble ..... oh by the way will the link work "NodeID" if i use this in a View?