You are currently viewing Stale Records vs Orphan Record In CMDB

Stale Records vs Orphan Record In CMDB

In ServiceNow’s Configuration Management Database (CMDB), “stale” and “orphan” records refer to two common data quality issues that can arise in the CMDB.

What is a stale record?

Stale records in the ServiceNow CMDB are configuration items (CIs) that have become outdated or no longer reflect the current state of the associated IT assets. Stale records can occur due to various reasons, such as hardware or software changes that haven’t been properly updated in the CMDB.

An example of a stale record

Let’s say you have a CI representing a server in the CMDB. If that server has undergone hardware upgrades or has been decommissioned, but the CMDB still shows outdated information, such as the old hardware configuration or the server’s status as active when it’s not, then those are examples of stale records.

What are orphan records?

Orphan records in the ServiceNow CMDB are configuration items (CIs) that exist in the CMDB but are not properly related to other CIs or do not have valid relationships. Orphans can occur when CIs are created but not associated with the appropriate parent or child CIs, leading to data inconsistencies.

Example of orphan record

Imagine you have a CI representing a network switch in the CMDB. If this switch is not linked to any other CIs, like the servers or devices connected to it, or if it lacks the necessary relationships to show its place within the network topology, then it becomes an orphan record.

Both stale and orphan records can lead to inaccurate and unreliable data in the CMDB, which can affect IT asset management, change management, and incident resolution processes. It’s essential to regularly audit and clean up the CMDB to address these issues and ensure the accuracy and reliability of the data within it. ServiceNow provides tools and processes for managing and resolving these types of data quality issues.

Difference between Stale & Orphan records?

CriteriaStale RecordsOrphan Records
DefinitionOutdated or inaccurate data that no longer reflects the current state of a record.Records that exist in the system but are not properly related or connected to other records.
ExampleThis can lead to inaccurate decisions and confusion as the CMDB does not reflect the current state of assets.A network switch record that is not linked to any servers or devices in the CMDB, making it isolated.
CauseStale records result from data becoming outdated due to changes in the real-world IT environment that were not properly updated in the system.Orphan records are often created when records are added to the system but not associated with the correct parent or child records or lack proper relationships.
ImpactThis can result in incomplete and inconsistent data, making it difficult to understand how different components are related in the IT infrastructure.Can result in incomplete and inconsistent data, making it difficult to understand how different components are related in the IT infrastructure.
ResolutionTypically requires updating the record with correct and current information to eliminate inaccuracies.Requires creating relationships or linking the orphan record to the appropriate parent or child records to establish data consistency.
Common Management ToolUsed by CMDB administrators and IT asset managers to maintain data accuracy.Requires attention from CMDB administrators and data analysts to identify and establish relationships.
Examples of ResolutionUpdating hardware and software information for a server in the CMDB to reflect the current state.Associating a network switch record with the servers and devices it connects to in the CMDB.

In summary, while both stale and orphan records can lead to data quality issues in a CMDB, they have different causes and require distinct methods for resolution. Stale records involve outdated or inaccurate information, whereas orphan records involve missing or improperly linked data relationships. Resolving these issues is essential for maintaining an accurate and reliable CMDB.

Video Tutorials In English & Hindi

Leave a Reply