Configuration Item data migration

Considering that Configuration Item does not need to copy data from two different tables, and that it typically has a large volume of data, we recommend that you run the migration by using the batch update mode.

The out-of-box example data migration is based on the following key field:

  • current.phase

Note You can add additional fields if needed, but do not remove these two fields. 

Default settings:

Source Table

device

Target Table

device

Filter Condition

null(current.phase)

Field Mapping:

Target Field

Source Field

current.phase

 

Value Mapping:

Target Value Mapping Field

Mapping Type

Condition

Target Value

current.phase

fixedValue

istatus=null or (istatus~="Missing" and istatus~="Retired/Consumed" and istatus~="Return for Maintenance" and istatus~="Return to Supplier")

Active

current.phase

fixedValue

istatus="Missing" or istatus="Retired/Consumed" or istatus="Return for Maintenance" or istatus="Return to Supplier"

Inactive