Performance Analytics - % availability of CI - Outage Table

[Alex224]

Reaching out today as we’re currently stuck on trying to create a performance analytic report for our technology leadership. 

Exactly as it sounds, I want to create a PA report which shows the availability of the CI from the outage table in % format (i.e. Application XYZ has 99% uptime avg the last 365 days). However, we cannot figure out the script needed which is part of the equation in the indicators. I imagine a solution might be [[[number of hours per day] - [total hours of outage]] / number of hours per day]. 

Thanks for the help!

[ChrisSteinke2]

Hi Alex. The basic calculation is (Possible Uptime Duration - Outage Duration)/Possible Uptime Duration).

One way to do this in SN is to create a manual Indicator and enter a score for each month that is the total hours of potential uptime. In this way the manual Indicator could be re-used for each individual service or application. This works great for month to month calculations. For weekly, you would need a Manual Indicator with a weekly total, likewise for Daily you would need a Manual Indicator with available hours per day.

The only caveat is that this will give you numbers that are directionally correct, but not 100% accurate. In order to get 100% accurate you would need to add much more detail - exclude planned outages, change windows, there are also things like Committed Uptime which is different from Total Uptime but not the same as the Service commitment. If you need this level of detail then the Service Portfolio Management solution from ServiceNow is your best bet, as includes all these details and 'builds' the data for you in the Service Availability table in your instance.

Please let me know if this doesn't answer your question.

Regards,

Chris