How can I archive the pa_scores_l1 and pa_scores_l2 table in servicenow

msc
Tera Contributor

How can I archive the pa_scores_l1 and pa_scores_l2 table in servicenow. How can I take the condition for the past data I don't seen any created or updated fields here 

4 REPLIES 4

Guido Bernuetz
Giga Guru

these tables didn't have the standard timestamps. you may use the field 'start_at'. It stands for the period of the value. But it's not a standard date time field!

GuidoBernuetz_0-1736171771046.png

 

I am not a helpful hunter.
I will always try to give a meaningful and valid answer.

Hi @Guido Bernuetz , can we use the indicator reference field by dot walking and getting created field value og indicator record.

I think dot-walking is not working. The indicator reference is not a SN standard reference.
I think these PA tables are not original ServiceNow tables.

But, I don't get your point. The indicator is created only ones and is stable. How this should be used for backup based on time period?

I am not a helpful hunter.
I will always try to give a meaningful and valid answer.

AndersBGS
Tera Patron
Tera Patron

Hi @msc ,

 

Can you try to give some more context to your request? What is it that you would like to achieve? Is this due to data size that you want to remove old data or? 

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/