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

SWQL query?

er.vansh17091

Hi,

I want to add node category in SQL query. Can you please help me out for the same.

WHERE ( ( Nodes.[Stats].[ResponseTime] > Nodes.[Stats].[AvgResponseTime]+30 )

AND Nodes.[Stats].[NodeCategories] = "1")

Find more posts tagged with

Accepted answers

All comments

dgsmith80

Hi er.vansh17091

So your query needs to look more like this:

WHERE Nodes.ResponseTime > Nodes.AvgResponseTime AND Nodes.Category = '1'

The Orion.Nodes table already has the values, you were trying to pull.

- David Smith

Kenson - SolarWinds Authorized Partner

Training, Licenses & Professional Services

- LinkedIn

- Twitter

- Facebook

er.vansh17091

Thank you so much, David and Martin.

m-milligan

SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes
WHERE ( ( Nodes.[Stats].[ResponseTime] > Nodes.[Stats].[AvgResponseTime]+30 ) )
AND Nodes.Category = 1

Yours,
Martin

8:24 PM

Hi Martin,