Idash Predicted Missed do not show via reports

Products

• iDash Workload Automation

Issue/Introduction

Predicted Missed alerts are only available via the Dashboard for 24 hours. We were hoping to be able to run the report via the GUI to get the Predicted Missed alerts from the past.  The report only shows Missed and MET.  

Can the Predicted Missed alerts be pulled from the database somehow?

Environment

Release : 12.1

Component : IDASH WORKLOAD AUTOMATION AE

Resolution

Yes, you can pull this form the database by running the following query below:

select * from idash_sla_run where status = 'PREDICTED_MISS'

This will give a listing of the times that an SLA went into PREDICTED_MISS status. This can be additionally filtered by sla_name and deadline if you want to look at specific SLAs or days. If you filtered by sla_name and deadline but left the status off, you would get the progression of statuses for the SLA run that day.