how to delete 2 lakh records with out effecting performance ?

Manikantahere
Tera Contributor

what are the ways available in ServiceNow ?

1 REPLY 1

Anand Kumar P
Giga Patron
Giga Patron

Hi @Manikantahere ,

 

The Table Cleaner feature in ServiceNow helps delete old or unwanted data in batches, ensuring minimal impact on performance. To create a new Table Cleaner, go to sys_auto_flush_list.do, click New, and complete required fields like Table Name, Matchfield (e.g., sys_created_on), and Age in seconds. You can set conditions for deletion or remove all records of a specified age. Finally, click Submit to save and activate the rule, which will run with the next Table Cleaner job.

 

Please go through below kb articles

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0694151

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0717791

 

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand