service availability per month (cmdb_ci_outage) - Performance Analytics dashboard

[LeanNow]

I have to Calculate service availability per month across time.
Outage table

Service availability starts with 100% for every month
– Subtract from 100% only the following from the Outage
Tickets Table
– % of outage = duration of outage in minutes (Outage
End minus Outage Start) and then divide by the
number of minutes according to the number of minutes
in the month (see table next page)
– Calculate above only if field Outage Type from the
Outage Tickets Table = Total Outage
– In a separate tab, report the records 

Can you recommend me please?

[AndersBGS]

Hi @LeanNow ,

According to your requirement for seeing the service availability by month, you first of all need to conclude how time 100% refer to? When this is concluded, you will be able to do the calculation and data capture through performance analytics. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[LeanNow]

Month Number of Days Number of Minutes
January 31 44,640
February 28 40,320
February 29 41,760
March 31 44,640
April 30 43,200
May 31 44,640
June 30 43,200
July 31 44,640
August 31 44,640
September 30 43,200
October 31 44,640
November 30 43,200
December 31 44,640

– EXAMPLE
– SA_EXAMPLE_WEB in January 2023 uptime was 99.79%
– There were two outages in January for this service
– 01/11/23 for 53 minutes
– 01/20/23 for 40 minutes
– Total outage was sum of both outages: 93 minutes
or 0.21%
– % available of service was = 100% - (93/44,640) =
99.79%

My question goes to how can I create that calculation on the PA indicator. Can you help me or guide me a little bit please with Performance Analytics

[Aaron Guzman]

Hi @LeanNow if you are using Offerings or application services, have you looked into using "Service Availability"?

Documentation explaining feature and setup: https://docs.servicenow.com/bundle/washingtondc-it-service-management/page/product/service-portfolio...

Results would be generated on Service Availability Results table, Monthly records will be generated and you can look at that data when using PA.