I need a solid query that will allow me to pick and choose any specific nodes and or applications within a selected status code example below, but maybe a lot cleaner since I am no programmer
By Nodes below:
SELECT COUNT(Status) as Status FROM Orion.Nodes Where Status LIKE '1' AND NodeName LIKE '%SYSTEM1%'
OR (DisplayName LIKE '%SYSTEM2%')
OR (DisplayName LIKE '%SYSTEM3%')
OR (DisplayName LIKE '%SYSTEM4%')
OR (DisplayName LIKE '%SYSTEM5%')
Or similar but by Applications below:
SELECT COUNT(Status) as Status FROM Orion.APM.Application Where Status LIKE '1' AND Name LIKE '%APP1%'
OR (DisplayName LIKE '%APP2%')
OR (DisplayName LIKE '%APP3%')
OR (DisplayName LIKE '%APP4%')
OR (DisplayName LIKE '%APP5%')
But they may all have different names, but I want them to derive off of the status of the Node and or Application itself
Any help with this would be greatly appreciated so I can wrap up a few dashboard related projects
Thanks