CMDB Cleanup: How to clean-up CMDB_CI_COMPUTER table and its related records in ALM_HARDWARE table?

[PaulyFredrick]

Hi Folks, 

I primarily work on ITSM - my company decided to clean-up their CMDB and they want to get rid of a bunch of computers in the CMDB_CI_COMPUTER table - and make sure whatever is archived in CMDB_CI_COMPUTER also gets archived from the ALM_HARDWARE table. 

Can you give some pointers on how to accomplish this please? 

[HrishabhKumar]

Hi @PaulyFredrick ,

Check this kb article, might be helpful : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0758135

Thanks,

Hope this helps.

If my response turns useful, please mark it helpful and accept solution.

[PaulyFredrick]

Sorry - but this is not about Instance Performance or table rotation. I'd like to archive a few thousand computers in cmdb_ci_computer table and ensure that asset in alm_hardware table is also archived simultaneously. 

[Deepak Shaerma]

Hello @PaulyFredrick,

Deleting records is not an advisable approach. Instead, consider changing the status to "retired" or "disposed." However, if this is the sole requirement, I suggest using a fix script for records under 1000 to minimize performance impact.

Let me know if you need further assistance.

Best regards,

DEEPAK SHARMA