Re: Bulk CI retirement using Transform Map

Tanushree Maiti · 3 weeks ago

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

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.
In the Get started area on the Data Manager overview page, select Manage retirement definitions.
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.
On the Data Manager settings page, select Add definition.

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.

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti