Need to delete all records in my cmdb_ci table

sarah38
Kilo Contributor

When I go into tables and columns and select the table and click delete all records - it only deletes about 1500 records. That table has over 180,000 records and they all need to be deleted. I used this article (Home  London  London Platform Administration  Now Platform Administration  Table administration  Delete all records from a table) but it did not work for me. We understand that deleting that many records at once could cause problems so we will perform the action on a weekend when our system is not used..

1 ACCEPTED SOLUTION
2 REPLIES 2

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

sarah38
Kilo Contributor

Hi,

Thanks for the link. We used the Java Script solution and it worked very well.