Bulk record deletion from Computer table

[Community Alums]

System Data management option is not available in our instance. is this required additional role or plugin?

[Kalatheeswaran · Accepted solution]

Hi Suraj,

You can delete the bulk records from any cmdb_ci table using the CMDB Data Manager as a best practice.

https://docs.servicenow.com/bundle/rome-servicenow-platform/page/product/configuration-management/co...

What I would suggest is that instead of deleting those records you can archive them and restore it if you need it in future. That also can be done by CMDB Data Manager or by Archive rules. Once the archival of data completed, the data will be moved to archived tables. In this case the records will be moved to ar_cmdb_ci_computer table.

If you use Archive rules, that will archive the records batch wise and each batch contains 10000 records. Once after archiving the 10000 records you need to trigger it again to archive the next batch.

Using Archive Destroy rules you can specify how long the archived data to be available in the archived table.

[Community Alums]

Thank a lot for your reply. it will really help. 

May I know why i am not able to find computer if use Delete Or Archive policy. I am able to find computer if i select retire Policy only 

[Kalatheeswaran]

It is because you need to retire the records which need to be deleted or archived. Once after retiring the records you will be able to delete or archive them.

First write the Retire policy and then go with deleting or archiving the records.