- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Monday
Hi, I want to delete all the records from the mentioned tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Monday
Do you have any screenshot showing which table you are referring to? @PARAS_
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
why to delete? is this a business requirement?
if you don't delete they will still be there in legacy reporting tables
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
