cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 10

NPM Group availability report in swql

hi

 

need NPM Group availability report in swql on last 24 hours

 

 

0 Kudos
2 Replies
Level 13

There is already a report prebuilt for group availability. You can copy that and change the time.

BUT, if you need the SWQL here is an example:

SELECT 
C.Name AS [GroupName],
AVG(CS.PercentAvailability) AS [Availability]
FROM Orion.ContainerStatus CS
INNER JOIN Orion.Container C ON CS.ContainerID=C.ContainerID
WHERE CS.DateTime>ADDHOUR(-24,GETDATE())
GROUP BY C.Name

0 Kudos

its showing all group = 100 % , which is wrong 

Need

Group = ATM Branch

availability = Yesterday

 

 

KHI-DSL100
Critical100
Core100
MAPS-0b588e52-98cd-492d-a71f-0f9d83a752eb100
ATM Branch100
MAPS-b3aae102-a373-457f-ad80-ed30f1e2e4d3100
0 Kudos