Report to show availability percentage of CI on the Outage table based on outage downtime

[DhanishaSuresh]

Hi ServiceNow Folks,

I am new to ServiceNow Performance  Analytics, I want to present a report that shows  the percentage of availability of CI on the Outage table based on the downtime and the Total Time available by month.

I would appreciate any help thanks!

[AndersBGS]

Hi @DhanishaSuresh ,

If you would like to calculate the CI availability of a CI, you need to know how many CIs that are in total. For this example lets say that there is a 100. If then you think about it, each day contains 1440 minutes, hence you should calculate ((count of CI * 1440) - outage duration / (count of CI * 1440) * 100 ). Afterwards you can aggregate by month in the performance analytics widgets. 

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

best regards

Anders

[Elizabeth10]

Hi AndersBGS 
We are trying to report on MTTR using outages. I need to calculate the total duration of the outage per configuration item, divided by the number of incidents (task type) for that ci. 
example
INC000001 - CI= network  outage duration= 60 mins
INC000003 - CI network outage duration = 30 mins.

the MTTR for this CI would be 90 mins/2 (inc) 

I have tried metric definitions and configure function fields in reports but I can't get the results I need. Can you explain how/where to set this up? 
Regards
Elizabeth

[AndersBGS]

Hi @Elizabeth10 ,

From top of mind you should capture sum of outage duration in an automated indicator and also count of outage duration in another automated indicator. Afterwards you can take the sum/count to have the MTTR. At last, ensure that a breakdown based on configuration item is available, so that you can breakdown by configuration item. 

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

best regards

Anders

[Elizabeth10]

Hi Anders 
It wasn't the answer I was expecting, but it actually made me look at it from another angle so thanks. 🙂