Bulk CI retirement using Transform Map

[UshaK5308581747]

Hi All,

I need suggestions on the best approach to retire bulk CI/server records in CMDB. The requirement is to update Operational Status, Installed Status to Retired and also remove the existing relationships when CI retired without modifying system fields.

Currently ,I am trying through transform map like batch-wise, and sometimes the Updated ,Updated By fields are not modifying and sometimes they get updated with the latest date with my name.

I even added sysAutoFields(false) in my script.

[Tanushree Maiti]

Hi @UshaK5308581747 .

The most effective, best-practice approach is to use CMDB Data Manager to handle the status updates, paired with a business rule or Flow Designer to remove relationships. This method executes bulk retirement safely, preserves system fields, and removes stale relationships.

Refer Servicenow Documentation: Manage retirement definitions for CMDB Data Manager 

Procedure

1. Open either workspace:
   • Navigate to Workspaces > CMDB Workspace, and then select the Data Manager quick link on the Home view.
   • Navigate to Workspaces > Service Graph Workspace. Then, in the navigation panel, select the Governance icon. Then, in the Governance pane, select Data Manager overview.
2. In the Get started area on the Data Manager overview page, select Manage retirement definitions.
3. On the Data Manager settings page, review the Retirement definitions list view.
   1. Optional: Drill down to a definition and then, on the Retirement definition form, toggle the Active switch to activate or deactivate a definition.
   2. Optional: Edit the conditions on the definition.
   3. Select Save definition.
4. On the Data Manager settings page, select Add definition.
5. Fill out the Retirement definition form and then select Save definition.
    Field Description

   Active	Toggles the retirement definition between active and inactive.
   Table	Table that the retirement definition applies to. The retirement definition will be derived by all child classes of the specified parent class.
   Condition builder	Condition that reflects on what retirement means in the organization. Target CIs in Retire policies that belong to the specified table are set as specified in the retirement definition. You can, therefore, only use AND clauses in the definition. OR clauses aren't applicable.

[UshaK5308581747]

Actually, I need to retire approximately 100k CI's. So I tried batch-wise in the lower environment using the transform map script. However my script is behaving intermittently- it works successfully for some records but fails for others and modifying the updated field.

@Tanushree Maiti I am not sure how to load the data and retire the CI's using Data Manager