Hi guys,
To calculate the downtime duration for the last 30 days for API poller objects, i write this billo query but not work and i have validate control
please help to improve that
SELECT
n.Name AS [NAME],
n.StatusDescription AS [STATUS],
CONCAT(
SUM(DATEDIFF(minute, e.EventTime, GETDATE())) / 1440, ' days ',
(SUM(DATEDIFF(minute, e.EventTime, GETDATE())) % 1440) / 60, ' hours ',
(SUM(DATEDIFF(minute, e.EventTime, GETDATE())) % 60), ' minutes'
) AS DowntimeDuration
FROM
Orion.APIPoller.ApiPoller n
INNER JOIN
ORION.EVENTS e ON n.NODES.NODEID = e.NETWORKNODE
WHERE
e.EventTime >= DATEADD(day, -30, GETDATE()) -- Events within the last 30 days
AND n.StatusDescription = 'Down' -- Filter for objects with status 'Down'
GROUP BY
n.Name, n.StatusDescription
