Requires Access To:
Administrator Role in Service Manager
The Online Help contains a reference example showing how to import data that will populate the CI Map for existing CIs. However, it is missing certain info and steps; can more info be provided to round out the instructions found in the HEAT Service Management Online Help ?
Step by Step:
The first step is to gather the RecId values that you will need – this includes any CI’s you want to map, as well as the CI Named Rel Data table. The easiest way to get these values is to add them to an Export to Excel quick action, and export the set of values you’re working with (i.e. the results of a saved search of all CIs that meet your criteria).
Once you have the RecID values available, you’ll need to map them in a spreadsheet – it should contain 3 columns:
1. DataID (the CI Named Rel Data recId for the relationship between the CIs)
NOTE: Do not use the RecId of the CINamedRelConstraints as documented
2. SourceID (The downstream CI recId)
3. TargetID (The upstream CI recId)
Here’s a simple one-record example from the OOTB system: the DataID is the recId for the CI Named Rel Data relationship ‘Virtualizes’, then there is a CI Computer, and a CI Virtual Server that will be linked to it.
This record is entered in an Excel spreadsheet, and saved as .csv. I named the file ‘CIMapDemo.csv’.
We then create the data import connection:
Log into the Admin role
Select Configure Application
Select Integration Tools – Data Import Connection
Select Add New
I named mine ‘CI Mapping Import’ and selected Manual File Upload
Browse to the import file created above and choose Next
Give the mapping name
Highlight SourceID as the unique key (if it is not unique, add a row number column to your import file and use that value)
Search for the CINamedRelLink# object and highlight it in the Target Business Object section
Choose Next twice (skip filters)
Select Auto Map – it should map the 3 fields
Choose Publish & Run Now
Once the import is done, you should be able to refresh the affected record(s) and view the CI Map: