How to calculate year to date uptime availability for CIs via the cmdb_ci_outage table

[Julie Gordon]

This is my first time working with Indicators, Breakdowns & PA, so I'm open to any advice.  

Goal is to have a PA widget to show the percentage uptime/availability for each of 12 CIs.

I have my Indicator Source: Outages created this year & Duration not empty

Breakdown Source: Outages by CI, created this year

Automated Breakdown by CI: Outage table mapped to CI field

Automated Indicator: Minimize/Minutes/Indicator source above, aggreate SUM of Duration field & set the Breakdown to my Breakdown indicator above.

When I check the scores for my indicator, they appear mostly correct.

However, when I'm trying to make a Formula Indicator, I'm messing up the formula and getting some crazy percentages. 

I thought I had everything calculating by day/minutes, so I used the 1440 number of minutes in the day, but not sure how to show this as a year-to-date percentage.

I think I'm getting a couple concepts mixed up in the formula part.  Appreciate any help!

[AndersBGS]

Hi @Julie Gordon ,

Please try to explain the formula - what were you throughs when crating this? I guess that the uptime / availability in percentage should be based on this year - correct? What do you mean by in regards to the score " they appear mostly correct."?

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

best regards

Anders 

[Julie Gordon]

Anders-  Thanks for replying. 

When I say the scores are mostly correct, I'm not sure why it's throwing in the Password Self-reset line item when there are no outages against this CI this year.  Other calculated times are correct. 

As for the formula, I'm winging it.  Yes, uptime / availability in percentage should be based on this year.  I've seen formulas to calculate daily % & monthly, but I'm at a loss on how to calculate that moving year to date %.  I know the formula above is wrong, but I've also tried using (1440 - [[JG-Outage duration?]]/1440) and the widget shows 1439%.  My thought was if I'm calculating daily, then I take the (minutes in a day - outage / minutes in a day).

Also, I'm assuming a 24/7 availability. 

[AndersBGS]

Hi @Julie Gordon ,

First, the "Password Self-reset" can/should be excluded if you don't need it in the automated breakdown. Secondly, and according to your year to date uptime, the calculation should be as below:

[[Sum of outage]] / (([[Count of CIs]] * 1440) / 100)

Remember, to get the uptime on daily basis, you need to know what is the uptime for the measured CIs. E.g. if you have 5 CIs, then you need to have 5 x 1440, as the outage duration for all 5 CIs measured in min could potential be 7200 mins (5 CIs down all 24 hours).

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

best regards

Anders 

[Julie Gordon · Accepted solution]

Anders-  Thank you again for your help.  Didn't event think of excluding the Password Self-reset CI.  GENIUS!

Also, I think we have it solved for our needs.  I realized I needed to show the Widget as a Breakdown instead of a Score.  Also, went with a simpler formula and broken down by CIs with outages. 

Thank you again for your time!!