How to fetch daily indicator scores for past 6 months or more?

[Veer_P]

The OOB box dashboard "IT Executive" gives the Number of Active SLA (daily), and I can export it.
How do I fetch the records from March 18 till date?

[AndersBGS]

Hi @Veer_P ,

The pa_scores table (or pa_scores_l1 and pa_scores_l2 depending on when you instance was created) hold all the scores for automated and manual indicators. By query the right data in one of these tables, you should be able to export the data.

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

Best regards

Anders 

[Veer_P]

Thanks Anders!
I need the records while these 2 tables hold the scores.

[AndersBGS]

Hi @Veer_P ,

You can fetch the single records through the analytics hub by showing records for the automated indicator: 

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

Best regards

Anders 

[SANDEEP28]

@Veer_P To get historical data (last 6 months), you need to run the historical jobs. You need mention below details in job and attach it to indicatory then execute.

Once job is successfully execute, you can go analytic hub of that indicator and select the 6 month duration to see the graphical view.

Click on "show records" to get the list view of records to extract it.

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