Is it possible to export PA scoresheets?

[Darrion Burges1]

Hello all, 

I would like to know if it is at all possible to export the scoresheets for a specific indicator. For example, we have several manual indicators that were constructed painstakingly by importing data into the manual indicators by hand. 

Now, we are ready to move these manual indicators to a new instance, and it would save hours of time if we could also export the scoresheets associate with these manual indicators. We are currently using Istanbul but are quickly on our way to upgrading to Kingston. 

My Question: is it possible by Kingston to export the scoresheets for a specific indicator? If so, how would we go about doing it. 

Bonus: if it is not possible, what are best practices around filling manual indicators with external data? 

Thank you for your time and expertise. 

[Adam Stout]

It depends... If you are using the pa_scores table you can just export data from there like any other table and import it to the new instance.  However, if you are using the pa_scores_l1 and pa_scores_l2 tables, while you can export them, you can't import them.

The suggestion I have for large manual data efforts is to load them into a new table then run PA on top of that table.  That will allow you to move them as needed as well as bulk load them from Excel.

[Darrion Burges1]

Thanks Adam, 

Let me see if I have this correct, the scores table is the score that you find if you click on an indicator scorecard-> scores tab. Meaning, anything in this scores tab can be exported like any table. 

However, can you tell me about scores level 1/2? our instance has it all as blank, but i'm still having trouble finding any of the scoresheets related to our manual indicators. From my perspective, it seems like the scores tables simply captures score for automated indicators

[Adam Stout · Accepted solution]

The scores tab you're referring to is most likely the scoresheet, not the base table itself.  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.  Formula indicators are not there since they are calculated on the fly.

Here is some more info on pa_scores, l1 and l2: https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/performance...