Bulk record deletion from Computer table

Community Alums · ‎01-18-2023

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

Kalatheeswaran · ‎01-23-2023

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.

View solution in original post

Omkar Kumbhar · ‎01-18-2023

Hello @Community Alums ,

Can you please navigate to Application menu and check once if it inactive

Thanks,

Omkar

If I was able to help you with your case, please click the Thumb Icon and mark as Correct.

Community Alums · ‎01-18-2023

Thank you for your response.

I checked this option but no luck.

Community Alums · ‎01-20-2023

i got to know from SNOW support team, Data management option available only in Tokyo Version family. we still have San diago version.

I want to delete 35k out of 45k record from cmdb_ci_computer table. may i know the best option to do the same.

Omkar Kumbhar · ‎01-20-2023

@Community Alums you can write the Fix script for deleting the records and make sure to add conditions while quering the cmdb_ci_computer table to ignore the 10k which you dont want to delete.

Thanks,

Omkar

If I was able to help you with your case, please click the Thumb Icon and mark as Correct.