I need the query SWQL that generates the Group Availability report (with members) - this months

Greetings to the community,

I would be needing the query that generates the Group Volability report (With Members) - This months to generate a widget, where can I get it? Or if someone knows it, I can share it. Thank you

Find more posts tagged with

swql query

query

npm

Accepted answers

All comments

Lofstrand

Hi, the easiest way is to use a "custom table" widget, in the datasource for that choose the groups you want (or all groups) and configure the columns like below. Then you will have last 30 days availability for the group and it's members. No need for a SWQL query.

mjonathan

thanks for the response, there I got the query I need. I asked since I needed to create a widget on a modern dashboard with that information
this would be the query that I was able to put together, it is basically the sum of the availability per group

SELECT ROUND(AVG(r.Availability), 0) AS GroupAverageAvailability
FROM Orion.Nodes AS n JOIN Orion.ContainerMembers AS cm ON n.NodeID = cm.MemberPrimaryID
JOIN Orion.Container AS c ON cm.ContainerID = c.ContainerID
JOIN Orion.ResponseTime AS r ON n.NodeID = r.NodeID
WHERE c.ContainerID = 1 AND DATETRUNC('hour', r.DateTime) >= DATETRUNC('hour', ADDDATE('hour', -24, GETDATE()))