Remove mass CI

[ayush_g]

I need to delete all CIs items that is more than crores from specific one Unique certificate class

[PritamG]

frist go to the CI table and navigate to cmdb_ci.list or the specific CI class list then filter the records and Use the filter condition select all filtered records using the checkbox at the top delete the records and confirm the deletion when prompted.

[ayush_g]

I am from BAU Team and not  Delete menu is disable for me.

[ayush_g]

Total Class Records counts are 1 lac 37 thousands so plase suggest the best solution as counts is too huge

[Marshall Parker]

There are different methods (as mentioned in an earlier comment) but for speed against volume, without locking tables from other updates, the Table Cleaner method may be best for deletion of bulk volume.

This does require admin role and I would always recommend checks to make sure you don't need any of the records & building the table cleaner in non-prod first to confirm it is working as expected before deploying to a Prod instance.  But in these scenarios, I have used the cleaner for many similar use cases.