Cherwell to Ivanti Link Migration Example

This example shows how the #OBJECT_RELATIONSHIP form can be used in conjunction with the Ivanti #LINK_CREATOR target to migrate Cherwell relationships to Ivanti. This particular use case is looking at the relationships between Incidents and CI's.

Source Filtering

The source filter below will retrieve the 'Incident Link Configuration Item' relationships for the Incidents migrated in the earlier form mapping.

Note that the source query identifies the Cherwell Business Object type name of the Relationships that are going to be migrated. The inclusion filter identifies the set of RecId's of source records whose relationships will be migrated.

Field Mappings

Notes on field mappings

1. A temporary value is used to store the Asset Tag, looked up from the Source Configuration item (see lookup of source configuration item below) The Asset tag is assumed to be the same on the source and target, and hence can be used to correlate CI records.
2. A reference mapping is used to get the incident RecId. This makes use of the correlation information collected in the earlier mapping that migrated the incident records.
3. The related object Id (i.e the ID of the CI) uses a second lookup to search the target table for the asset tag obtained in (1) - see target configuration item below.
4. The name of the target relationship is hard-coded here.

Lookup of Source Configuration Item

Lookup of Target Configuration Item

Related Articles

Retrieving Object Relationship Information from Cherwell

Creating Object Relationships in Ivanti