How can we measure hours of downtime?

oana5
Giga Contributor

3 REPLIES 3

Vincent Loffel1
Kilo Guru

Hi Oana,



This depends on the way it is stored in ServiceNow. If you use the outages table/module in ServiceNow, you could use performance analytics to calculate the outage per service and calculate for instance the percentage of availability, or the hours of down time on any given day.



Cheers,


Vincent


With Explore Analytics, you can get live reporting or historical reporting to calculate the length and impact of outages. For example, this report:



Screen Shot 2016-03-15 at 3.40.21 PM.png



This is a live, interactive report embedded in the ServiceNow dashboard, that's showing the % Uptime and the Mean Time Between Failures based on the duration of the outage. (You can also generate it as a difference between two date-times).



The Uptime calculation looks like this:



In that example, we're automatically rolling up incidents that are associated to individual CIs to their upstream business service, something no other reporting can do.



So for example in this report, you can see the outages that are opened against individual CIs (ALDWXP and DC01) impact upstream services (Bond Trading, Uber Service).


Screen Shot 2016-03-15 at 3.41.17 PM.png



Explore Analytics can also combine information from multiple tables, like this report combining the % of tasks meeting SLA with the % availability of the same service:



Screen Shot 2016-03-15 at 3.41.06 PM.png


factana
Giga Contributor

To measure hours of downtime, you can follow these key steps:


Manual Method (Paper/Spreadsheet)

  1. Log Downtime Events: Record the start and end time of each equipment or system failure.

  2. Calculate Downtime:

    Downtime (hours)=End Time−Start Time\text{Downtime (hours)} = \text{End Time} - \text{Start Time}Downtime (hours)=End Time−Start Time
  3. Sum It Up: Total the downtime durations over a shift, day, week, or month.


Automated Method (Using CMMS Software like Fogwing CMMS)

  • Real-Time Tracking: Automatically logs start and end times when a machine stops.

  • Auto-Calculation: Calculates total downtime per asset or location.

  • Reports & Dashboards: Visualizes downtime trends (daily/weekly/monthly).

  • Threshold Alerts: Triggers maintenance tasks if downtime exceeds limits.

Fogwing CMMS is a powerful tool for this. It's widely used across the US, UK, Europe, Middle East, Australia, and India for tracking and reducing downtime with real-time insights and automation.


 Metrics to Monitor

  • Total Downtime Hours

  • Mean Time Between Failures (MTBF)

  • Mean Time To Repair (MTTR)

  • Downtime % = (Downtime / Total Time) × 100