Relations in the ServiceNow CMDB can easily get out of control, leading to performance problems and reduced data quality. To help address this, the script below provides a safe way to clean up the cmdb_rel_ci table—for example, after mass-updating the Operational State of CIs or after mass-deleting CIs.

Because a ServiceNow CMDB can contain millions of relations—and because these relations drive impact analysis—it is critical to keep the table contents clean. When a CI is removed, its relations should also be removed. While I generally recommend retaining CIs that are no longer in use or discovered, I also advise removing relations that involve retired CIs. This prevents outdated dependencies from influencing impact calculations e.g. done by AI or OOTB flows, and user being able to select retired related items in operational processes.

With that in mind, I apply a simple rule:

Every relation must have both a parent and a child.
Both the parent and child must exist.
Neither parent nor child may be Retired.
All other relations are invalid and should be removed.

Note: ServiceNow does not support retiring relations, which actually makes sense.

That is precisely what the fix script below does—and more:

Preview or Delete: Control behavior by setting Preview Only to true (preview) or false (delete).
Targeted Query: Identifies obsolete relations where the parent or child does not exist, or the operational status is 7 – Retired.
Preview Mode: Generates a CSV report of all invalid relations (including Parent, Child, and Type).
Delete Mode: Removes invalid relations in controlled “chunks” of 500 to avoid timeouts or performance issues.
Summary: Displays the total number of deleted relations once completed.
Rollback: Deletions can be reverted if required.

Disclaimer:

This script is provided ‘as is’ and without any warranty or guarantee of any kind, express or implied. Use this script at your own risk. The author assumes no responsibility or liability for any errors, issues, damages, or losses resulting from the use or misuse of this script.

TIP: Prevention is better than Fixing

If you have a CMDB with a lot of CIs, you may want to create a scheduled job that automatically removes obsolete/invalid relations daily or weekly. For CMDBs with a relatively low number of CIs and little turnaround, you could create a business rule that removes all relations where the current CI is either parent or child, when a CI is deleted or updated (i.e., on a real-time basis). Those using a Vancouver+ Release of ServiceNow should use the OOTB “CMDB (Relationship) Health” capability.

Fix Script to Clean Up Invalid/Obsolete CMDB Relationships:

Copy to Clipboard

// Fix Script: Cleanup of invalid CMDB relationships with Execution Log Output + Progress Counter + Timer + Early Exit + Configurable Parameters
//
// By Jeroen A. van Craaikamp. www.JAvC.nl
// Revision 4.0, September 7th 2025
//
// Disclaimer:
// This script is provided as is and without any warranty or guarantee of any kind, express or implied. 
// Use this script at your own risk. The author assumes no responsibility or liability for any errors, 
// issues, damages, or losses resulting from the use or misuse of this script.
//
// Deletes relationships where:
//   - Parent CI missing
//   - Child CI missing
//   - Parent CI Retired (operational_status = 6)
//   - Child CI Retired (operational_status = 6)
//
// === CONFIGURATION PARAMETERS ===
// previewOnly     : true  = Preview mode (no deletions, logs invalid relations)
//                   false = Delete mode (invalid relations will be removed)
// chunkSize       : Number of relationships deleted per batch in Delete mode
// retiredValue    : Integer value for "Retired" (OOTB = 6)
// previewLogLimit : Max rows logged in Preview mode (truncated if exceeded)
// progressStep    : Log progress every X processed relationships (set 0 to disable)
// =================================

(function() {
    // === CONFIGURATION ===
    var previewOnly      = true;    // set to false to actually delete
    var chunkSize        = 500;     // number of rows to delete per batch
    var retiredValue     = 6;       // integer for "Retired"
    var previewLogLimit  = 500;     // max rows to print in preview mode
    var progressStep     = 1000;    // log progress every X relationships processed (0 = disabled)
    // =====================

var start = new Date();
    var startMs = start.getTime();
    var startStamp = start.toISOString();

// Log mode at start
    if (previewOnly) {
        gs.info("[CMDB Cleanup] START " + startStamp + " | Mode: PREVIEW (no deletions).");
    } else {
        gs.info("[CMDB Cleanup] START " + startStamp + " | Mode: DELETE (invalid relationships will be removed).");
    }

var gr = new GlideRecord('cmdb_rel_ci');
    gr.query();

var count = 0;      // invalid relations found
    var total = 0;      // total processed
    var toDelete = [];
    var logged = 0;

// Header only in preview mode
    if (previewOnly) {
        gs.info("sys_id,parent_sys_id,parent_name,parent_class,parent_operational_status,type,child_sys_id,child_name,child_class,child_operational_status");
    }

while (gr.next()) {
        total++;

var parentValid = true;
        var childValid = true;

var parentSysId   = gr.parent ? gr.parent.toString() : "";
        var parentName    = "";
        var parentClass   = "";
        var parentStatus  = "";

var childSysId    = gr.child ? gr.child.toString() : "";
        var childName     = "";
        var childClass    = "";
        var childStatus   = "";

// Check parent CI
        if (!gr.parent) {
            parentValid = false;
        } else {
            var parentCI = new GlideRecord('cmdb_ci');
            if (parentCI.get(gr.parent)) {
                parentName   = parentCI.getValue("name");
                parentClass  = parentCI.getValue("sys_class_name");
                parentStatus = parentCI.getDisplayValue("operational_status");
                if (parentCI.getValue("operational_status") == retiredValue) {
                    parentValid = false;
                }
            } else {
                parentValid = false; // parent missing
            }
        }

// Check child CI
        if (!gr.child) {
            childValid = false;
        } else {
            var childCI = new GlideRecord('cmdb_ci');
            if (childCI.get(gr.child)) {
                childName   = childCI.getValue("name");
                childClass  = childCI.getValue("sys_class_name");
                childStatus = childCI.getDisplayValue("operational_status");
                if (childCI.getValue("operational_status") == retiredValue) {
                    childValid = false;
                }
            } else {
                childValid = false; // child missing
            }
        }

// Invalid relation → mark for deletion or preview
        if (!parentValid || !childValid) {
            count++;

if (previewOnly) {
                if (logged < previewLogLimit) {
                    gs.info([
                        gr.sys_id,
                        parentSysId,
                        parentName,
                        parentClass,
                        parentStatus,
                        gr.type,
                        childSysId,
                        childName,
                        childClass,
                        childStatus
                    ].join(","));
                    logged++;
                }
            } else {
                toDelete.push(gr.sys_id.toString());
                if (toDelete.length >= chunkSize) {
                    deleteChunk(toDelete);
                    toDelete = [];
                }
            }
        }

// Progress counter
        if (progressStep > 0 && total % progressStep === 0) {
            gs.info("[CMDB Cleanup] Processed " + total + " relationships so far...");
        }
    }

var duration = Math.round((new Date().getTime() - startMs) / 1000);

if (count === 0) {
        gs.info("[CMDB Cleanup] FINISHED | No invalid relationships found out of " + total + " processed. Duration: " + duration + " seconds.");
        return;
    }

if (previewOnly) {
        if (count > previewLogLimit) {
            gs.info("[CMDB Cleanup] Output truncated: " + (count - previewLogLimit) + " more rows not shown.");
        }
        gs.info("[CMDB Cleanup] FINISHED | " + count + " invalid relationship(s) found out of " + total + " processed. Duration: " + duration + " seconds.");
    } else {
        if (toDelete.length > 0) {
            deleteChunk(toDelete);
        }
        gs.info("[CMDB Cleanup] FINISHED | Deleted " + count + " invalid CMDB relationship(s) out of " + total + " processed. Duration: " + duration + " seconds.");
    }

function deleteChunk(sysIds) {
        var del = new GlideRecord('cmdb_rel_ci');
        del.addQuery('sys_id', 'IN', sysIds);
        del.deleteMultiple();
        gs.info("[CMDB Cleanup] Deleted chunk of " + sysIds.length + " records.");
    }
})();

📄 Sample Output

🔎 Preview Mode (`previewOnly = true`)

*** Script: [CMDB Cleanup] START 2025-09-07T10:15:32.123Z | Mode: PREVIEW (no deletions).

*** Script: sys_id,parent_sys_id,parent_name,parent_class,parent_operational_status,type,child_sys_id,child_name,child_class,child_operational_status

*** Script: 0f7a1234abcd5678,parent123,App Server,cmdb_ci_server,Installed,Depends on,child456,Database,cmdb_ci_db_instance,Retired

*** Script: 0f7a2234abcd5678,parent999,Old Switch,cmdb_ci_network,Retired,Depends on,child888,Router,cmdb_ci_network,Installed

*** Script: [CMDB Cleanup] Processed 1000 relationships so far...

*** Script: [CMDB Cleanup] Processed 2000 relationships so far...

*** Script: [CMDB Cleanup] Output truncated: 145 more rows not shown.

*** Script: [CMDB Cleanup] FINISHED | 645 invalid relationship(s) found out of 12,480 processed. Duration: 18 seconds.

Key points:

Shows first N (configurable) invalid rows in CSV-style.
Progress every 1000 processed.
Final summary includes totals and runtime.

Delete Mode (previewOnly = false)

Key points:

No CSV rows are printed (only counts).
Relationships are deleted in chunks.
Each chunk deletion is logged.
Final summary shows deleted count, total processed, and runtime.

Runbook

Purpose

This script identifies and removes invalid CMDB relationships in cmdb_rel_ci.
Invalid relationships are those where:

The parent CI is missing, or
The child CI is missing, or
The parent CI is Retired (operational_status = 6), or
The child CI is Retired (operational_status = 6).

Configuration Parameters

Located at the top of the script:

previewOnly
- true = Preview mode (no deletions, logs invalid relations)
- false = Delete mode (removes invalid relations)
chunkSize
- Number of records deleted per batch (default: 500).
- Used only in Delete mode for safety.
retiredValue
- Integer value for “Retired” (6 by default).
previewLogLimit
- Maximum invalid relations logged in Preview mode (default: 500).
- Output is truncated if more are found.
progressStep
- Log progress every X records processed (default: 1000).
- Set to 0 to disable progress logging.

▶️ How to Run

Step 1 – Preview Mode (safe check)

Open Fix Scripts (or run in Background Scripts).
Paste the script and set:

var previewOnly = true;
Execute the script.
Check the System Log for output:
- First 500 invalid relationships (configurable).
- Total invalid relationships found.
- Progress updates every 1000 processed.
- Runtime in seconds.
If No invalid relationships found → stop here, nothing to clean up.

Step 2 – Delete Mode (actual cleanup)

Confirm the Preview Mode results with your CMDB/data owner.
Change the config:

var previewOnly = false;
Execute the script.
Monitor the System Log:
- Deletion occurs in safe chunks (default: 500).
- Each chunk deletion is logged.
- Summary shows total deleted + duration.

🔒 Safety Notes

Always run Preview Mode first.
Review output with CMDB/data owners before deletion.
Adjust chunkSize for very large CMDBs to avoid timeouts.
Script logs a start timestamp, progress, and total runtime for traceability.

Fix Script to remove obsolete/invalid CI Relations, with preview option

TIP: Prevention is better than Fixing

Fix Script to Clean Up Invalid/Obsolete CMDB Relationships:

📄 Sample Output

🔎 Preview Mode (`previewOnly = true`)

Runbook

Purpose

Configuration Parameters

▶️ How to Run

Step 1 – Preview Mode (safe check)

Step 2 – Delete Mode (actual cleanup)

🔒 Safety Notes

Leave A Comment Cancel reply

Fix Script to remove obsolete/invalid CI Relations, with preview option

TIP: Prevention is better than Fixing

Fix Script to Clean Up Invalid/Obsolete CMDB Relationships:

📄 Sample Output

🔎 Preview Mode (previewOnly = true)

Runbook

Purpose

Configuration Parameters

▶️ How to Run

Step 1 – Preview Mode (safe check)

Step 2 – Delete Mode (actual cleanup)

🔒 Safety Notes

Share This Story, Choose Your Platform!

Leave A Comment Cancel reply

🔎 Preview Mode (`previewOnly = true`)