Performance analytics application availability

[Swetha M]

Hi Team,

I have a requirement to fetch the application availability for Criticality 1,2,3 applications. We need reports to show availability in percentage and in Mins.

I have created indicators and breakdowns accordingly based on data in cmdb_ci_outage table data, where my configuration Item field would reference the cmdb_ci_appl table and dotwalk to fetch criticality of applications.

Since Im new to PA, wanted some inputs on how to fetch the availability details in a report/widget. Now i have the outage duration, so i would need a formula indicator to calculate total available mins in a month - outage duration.

I'm not sure if i can use a formula indicator, if so, where would I include these.

Any inputs would be really appreciated 🙂 Thanks in advance!

[G Ponsekar]

Hi @Swetha M ,

you can try with below steps:

1. you already created Automated indicator cmdb_ci_outage table, focusing on outage duration.

• Ensure your indicator source for these indicators targets the cmdb_ci_outage table and includes appropriate filters (e.g., specific outage types, states).
• Your breakdown on the Configuration Item field, dot-walking to the cmdb_ci_appl table to fetch the application criticality, is a good foundation.
• Verify that your breakdown is configured to group or categorize outages by the criticality field, e.g., with elements for "1 - most critical", "2", and "3"

2. Formula indicator for availability in minutes

• Frequency: Set this to "Monthly" to match your calculation.
• Unit: Select "Minutes".

• The formula should subtract the "Outage Duration" (from your automated indicator) from the "Total Available Minutes" in the chosen collection period (e.g., "Monthly").
• You can reference your existing automated indicator by name or sys_id within the formula

Example: 

((1440 * 30) - [[Outage Duration.Sum]] )

- This example calculates availability for a 30-day month (1440 minutes/day * 30 days) minus the sum of the outage durations collected by your automated indicator ("Outage Duration.Sum").

3. Formula indicator for availability percentage

• Frequency: Set to "Monthly".
• Unit: Select "Percentage"

Use formula: 

((((1440 * 30) - [[Outage Duration.Sum]]) / (1440 * 30)) * 100)

- This formula divides the "Availability in Minutes" by the "Total Available Minutes" and then multiplies by 100 to get the percentage.
- Again, adjust "Total Available Minutes" based on your needs. 

4. Widget Configuration

In Dashboard, you can add

• core Widgets: Display the latest availability score for each criticality level (1, 2, 3) in minutes and percentage.
• Time Series Widgets: Visualize the availability trend over time for each criticality level.
• Breakdown Widgets: Show the breakdown of outages by criticality and other relevant attributes.

• For each widget, select the appropriate formula indicator ("Application Availability (Mins)" or "Application Availability (%)").
• Configure the breakdowns to view the availability scores broken down by the "Application Criticality" derived from your dot-walking setup

5. Schedule for data collection

Ensure your data collection jobs are running regularly (e.g., nightly, monthly) to update the scores for your automated and formula indicators.

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[Swetha M]

@G Ponsekar  Thanks for responding!!

I have configured all the above steps already and Iam able to see data in my widget.

However, I have also used static value for 30- day month in mins. There are months with 31 days and also 28. How would we make changes accordingly? This is where iam stuck. My current formula indicator is using minutes for 30 day month only

[G Ponsekar]

Hi @Swetha M ,

To get days of month dynamically, create an Automated Indicator on any facts table and use collection script 

var now = new GlideDateTime();var days = now.getDaysInMonthUTC();// Return the number of days multiplied by 1440 (60 minutes * 24 hours) to get total minutescurrent.setValue(days * 1440);

Aggregation: SUM (or AVG, it doesn't matter since there will only be one value per month).

Frequency: Set to Monthly.

Collection: Ensure this indicator is added to a data collection job that runs monthly.

And then update the formula indicators -> Add above newly created automated indicator using "Browse Indicator" search

Update formula like

([[Days in Current Month]] - [[Outage Duration.Sum]] )

Similarly goes to next formula

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[Swetha M]

Iam not able to figure out which facts table i should use . I have to use an indicator source and also some facts table in script record, right? I tried using outage table and cmn_schedule tables, but the output value is not correct.