CMDB Dashboard/Stale Relationships

[Steven Barber]

Hello all,

I was looking at the CMDB Dashboard/Relationship Health tab

I have over 48,000 stale relationships.

Can anyone tell me how to remove these?

Thank you.

[Dr Atul G- LNG · Accepted solution]

Hi @Steven Barber 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0952407#:~:text=These%20relat....

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

[AJ-TechTrek]

Hi @Steven Barber 

The stale data usually means that the CI is no longer identified in Discovery, SG Connector or by other means that update the CI regularly from its source.  

I would recommend using the CMDB Data Manager to setup policies and workflow to deal with the Stale CI.  This will allow you to mark it as retired, or move it to archive or deleted when your policy rules have been met.  This overview will help understand how Data Manager works and the types of policies you need to start setting up. 

We also have a new Data Foundations Dashboard to help identify stale CI's and address them.  It's available in the store here.  It supplements the current Out Of Box health dashboard with additional details such as prioritization, and links to KB article playbooks that provide a thorough explanation on how to address each health scan issue, including stale CI's. 

There is a system property that lets you set the stale CI during like 60days or 90days ETC..., its recommended to set the stale CI to ''Retired' instead to delete them. (yes you can do that , they will not more be discovered by Discovery or SGConn)You can also plan for remediation task to CMDB team to review them regularly and see if there is no active relationship on the Stale CI.

https://www.servicenow.com/community/itom-forum/deletion-strategy-for-cmdb-ci/m-p/961148

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/