Node outages for the last day with duration

Report lists all node outages occurring within the last day, showing start/end time of the outage and total duration in minutes.

Sample output:

Anonymous
  • Hi
    There is time period issue from mention query , it's not showing data in report after 12:00 AM

    My time zones is gmt +5

    WHERE (i.DateTime BETWEEN DATETRUNC('day', GETDATE()) AND DATETRUNC('day', ADDDAY(1, GETDATE())))