Trying to query number of devices by status. Getting false positives.

patchouli_prince

So I'm brand spanking new to SWQL and SQL , I'm currently creating a Dashboard with a widget that'll allow me to see the number of devices with a status of  Up, Down/Critical  or Warning. I have all of my UP devices as accurate and there should be none in a down or warning state. However, my query is generating devices as down and warning when they are known goods and also show in the Up category. 

My query goes a little something like: 

SELECT COUNT (STATUS) as Down

FROM Orion.Nodes

Where Status = 2 and IP_Address Like (x.x.x.x) or IP_Address Like (x.x.x.x)

I've also created a group for these devices thinking I would be able to specify the devices by Group Name to account for the expansion of this particular network but I haven't found the right captions for that yet. 

All help is appreciated!

JerryJHC_A

Hey,

For what I see in your query is it because you are mixing "and" && "or" conditions.

SELECT COUNT (STATUS) as Down

FROM Orion.Nodes

Where Status = 2 and ( IP_Address Like (x.x.x.x) or IP_Address Like (x.x.x.x) )

You have to group the IP_Address with brakets for example. And if you want to use Group you should use a Inner Join with the table Orion.Groups.

Hope it helps.