What are you doing to the CI relationships when you are retiring the CI?

Suggy
Giga Sage

‎03-14-2022 11:20 AM

What are you doing to the CI relationships when you are retiring the CI? How are you handling the relationships?

Manually? Automated? or Archiving ?

 

Thanks in advance

0 Helpfuls
  • 922 Views
3 REPLIES 3

Suggy
Giga Sage
In response to Anshu_Anand_

‎03-15-2022 03:34 AM

Hi @anshu

Can you share more details on how you are archiving? steps etc.

0 Helpfuls

Anshu_Anand_
Kilo Sage
Kilo Sage
In response to Suggy

‎03-15-2022 08:05 AM

Once in every quarter, I filter the Cis which are marked as retired.

I export these CIs into excel with related lists.(incidents, changes affected)

from cmdb_rel_ci, i get all its relationships exported.

filter on parent.ci is retired and child.ci is retired

Then Cleaned the orphan ,empty relationships via this script

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780988

I have to do this because, our cmdb has 9 million records, and every now and then their are duplicates due manual creation in past and retired.

Also no one is interested in a server which was retired 5 years ago. why to keep it then...

 

If you have a small cmdb database, you can leave the retired ones as it.

just remove the serial numbers(also from serial_number table) and ip address for that Ci , so that they could not be discovered anymore(in case the same asset hardware components changed but asset is same)

Hope its helpful

 

 

Regards,
Anshu
0 Helpfuls