Delete everthing from sys_report and pa_Dashboards and related tables

PARAS_ · Monday

Hi,

After migration to platform analytics planning to remove all the data from sys_report and pa_dashboards and related tables. What is the best way to achieve this?

I am not good at javascripting .

adityahubli · Monday

Hello @PARAS_ ,

I would recommend taking a backup before deleting any data, in case it is needed in the future.

You can delete data from the tables using configuration options available in ServiceNow, so there is no need to write any scripts.

How to delete/update bulk data without scripting :

For bulk record deleting there is OOTB option that is Data management .

Go to target table => filter out data which you want to delete ( apply OOTB filter functionality) =>Right click => In Context Menu => click on Data management => Delete with delete preview => cascade preview => execute now ( from related links) => wait filtered out records will get deleted

Another option is use Archive and Destroy rules, which first move records to an archive table before permanent deletion. The data stays there until it meets the destroy duration, and this method also allows you to include related records during cleanup.

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya,

Technical Consultant

View solution in original post

adityahubli · Monday

Hello @PARAS_ ,

I would recommend taking a backup before deleting any data, in case it is needed in the future.

You can delete data from the tables using configuration options available in ServiceNow, so there is no need to write any scripts.

How to delete/update bulk data without scripting :

For bulk record deleting there is OOTB option that is Data management .

Go to target table => filter out data which you want to delete ( apply OOTB filter functionality) =>Right click => In Context Menu => click on Data management => Delete with delete preview => cascade preview => execute now ( from related links) => wait filtered out records will get deleted

Another option is use Archive and Destroy rules, which first move records to an archive table before permanent deletion. The data stays there until it meets the destroy duration, and this method also allows you to include related records during cleanup.

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya,

Technical Consultant

adityahubli · Monday

Refer this attachment :

adityahubli · yesterday

Hello @PARAS_ ,

Does my response helps you ? if yes then mark it as helpful and accept as solution.

Regards,

Aditya,

technical Consultant

Dr Atul G- LNG · Monday

Hi @PARAS_

Are you looking to delete the record data or the reports?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************