SQL Filter on Node Category

Answer:

SQL Code:

To get the categories:

Select TOP 1000 [CategoryID], [Description]
FROM [SolarwindsOrion].[dbo].[NodeCategories]
0 - Other
1 - Network
2 - Server

Queries to run to list each Node Category:

SELECT * FROM [dbo].[Nodes] WHERE
NodesData_Category = 0

SELECT * FROM [dbo].[Nodes] WHERE
NodesData_Category = 1

SELECT * FROM [dbo].[Nodes] WHERE
NodesData_Category = 2

Find more posts tagged with

Node

sql

Database

report

node_details

Hi ... is there a question in there, or are you replying to a now locked 9yr old thread?