Configuring CMDB Mapping

Owned by Enterprise IT
Apr 22, 2024

Using the CMDB Mapping templates, data synchronization between the Asset Inventory and Configuration Management Database (CMDB) can be done easily (see: Dynamic Bidirectional auto sync of Asset Inventory and CMDB).  In these templates, field mapping is done based on the selected values of Asset Category and CMDB Classification. The user has to map the Asset and CMDB fields including the Custom Attributes. The user can configure multiple templates by specifying the Asset Category, CMDB Classification, Import Type, and Sync For value. The user can use the available configured templates when a Asset is added, or Asset details are updated in the Asset Inventory or CI is added or CI details are updated in CMDB. The template-based synchronization saves time and synchronizes multiple Assets and CI attributes at a time. This synchronization is useful during the Asset Discovery process. The SummitAl Service Management and SummitAI Asset Managementjointly allow CMDB import.

To configure CMDB Mapping Templates:

  1. Select Asset > Configuration > Mapping > CMDB Mapping.

  2. On the CMDB MAPPING page, select a Tenant and provide data in all the fields. Select appropriate Mapping Column for the Asset Attribute. For more information about the fields, see Field Description.

  3. Click SUBMIT. A CMDB Mapping template is configured. 

    CMDB MAPPING page - Import Type (Asset To CI Import)
    Figure:  CMDB MAPPING page - Import Type (Asset To CI Import)

    CMDB MAPPING page - Import Type (CI To Asset Import)

          Figure:  CMDB MAPPING page - Import Type (CI To Asset Import)

Custom Scheduler Job

The job, Asset - CMDB Data Sync., should be configured on the CUSTOM SCHEDULER page (see: Custom Scheduler) for Asset-CMDB data synchronization. This job is responsible for synchronizing the observed hardware and software variance data between the Asset Inventory and CMDB. This job should be configured on the SummitAI Application Server. It is recommended to schedule this job to run once in 30 minutes.

Field Description

This table describes the fields available on the CMDB MAPPING page.

Field

Description

Tenant

Select the Tenant for which you want to configure the mapping.

Template Name

Specify the template name.

Asset Category

Select the Asset Category. Based on the selected Asset Category, all the static and dynamic attributes are populated under the mapping column. The static attributes are Asset Code and Store Location.

CMDB Classification

Select the CMDB Classification. Based on the CMDB Classification, all the static and dynamic attributes are populated under the Mapping Column.

For example, if Network is set as CMDB Classification, all the attributes related to CMDB Master, Network, and Additional Information tab attributes are populated under the Mapping Column. If Others is set as CMDB Classification, all the attributes (SERVER, NETWORK, and DESKTOP) are populated under the Mapping Column.

Import Type

Select the Import Type as Asset to CI or CI to Asset. The Asset details are imported based on the selected criterion.

  • Asset to CI Import: If add or update action is performed on an Asset, based on the template mapping fields, data is synchronized to CMDB (Add new CI or update CI). For example, when an add action is performed on an Asset, a new CI is added to CMDB, and the Asset detail are added to that newly added CI, synchronizing both Asset Inventory and CMDB.

  •  CI To Asset Import: If add or update action is performed on a CI, based on the template mapping fields, data is synchronized to the Asset Inventory (Add new Asset or update Asset). For example, when an add acton is performed on a CI, a new Asset is added to the Asset Inventory, and the CI detail are added to that newly added Asset, synchronizing both Asset Inventory and CMDB.

Sync For

Select a value for Sync For. Following are the values of Sync For field:

  • Add: If the value of Sync For is configured as ADD on the template, and the add action is to be performed on an Asset, the system automatically picks up this template, and the import action happens accordingly.
  • Update: If the value of Sync For is configured as UPDATE on the template, and the update is to be performed on an Asset, the system automatically picks up this template, and the import action happens accordingly.

Note: The Workgroup, Workgroup Owner, Customer, and Criticality fields needs to be configured while importing the Asset details to CI for an add action. However, these fields are disabled while importing these details for an update action.

Owner WorkgroupThis mandatory field is displayed if the Import Type is selected as Asset to CI Import. Select the owner Workgroup of the CI. The selected Owner Workgroup is mapped to the newly created CI.

Owner

This mandatory field is displayed if the Import Type is selected as Asset to CI Import. Select the owner of the CI. The selected Owner is mapped to the newly created CI.

Customer

This mandatory field is displayed if the Import Type is selected as Asset to CI Import. Select the Customer of the CI. The selected Customer is mapped to the newly created CI.

Note:

  • The Customer field value is based on the Asset status, which takes precedence over the value provided on the CMDB MAPPING page. If the Asset is in Allocated status and has a Customer assigned to that allocation, the assigned Customer is considered. If no Customer is available for that allocation at that time, the Customer of the Allocated User is considered. If no Customer is available, the user-specified Customer value on the CMDB MAPPING page is considered.          
  • If the Allocated Asset has no Customer and Allocation is Multi-Allocation, the Customer of the latest user is considered.
  •  The Customer value specified by the user is second priority. 

Criticality

This field is displayed if the Import Type is selected as Asset to CI Import. Select the Criticality of the CI from the list. The selected Criticality is mapped to the newly created CI.

Store

This field is displayed if the Import Type is selected as CI to Asset Import. Select the Store. The selected Store is assigned to the newly imported Asset.

Note:

  •  The Asset Store field value is disabled for Update action when the Import Type is selected as CI to ASSET Import.
  • The location configured for the CI precedes over the user-defined Store value.
Scenarios
  • Scenario 1: If CI location value is available in Asset Management Location Master, the new Asset is added under the latest selected Store.
  • Scenario 2: If CI location value is not available in Asset Management Location Master, a new Location and Store is in Asset Management. The newly added Store is mapped to the CI.
  • Scenario 3: If CI location is not defined, the Store value configured in the template is considered.
  • Scenario 4: If CI location is not available in Asset Management Master, a new Location with same name and new Store (example Bangalore store) is created in the AM master, and the new Asset is added to that Store.
  • Scenario 5: If CI location is available in Asset Management Master but no Store is available under it, a new Store is added and the Asset it added to it.

Conditions

Displays the configured conditions. Click  icon to specify the conditions. For more information about configuring conditions, see Field Description.

Active

If selected, this CMDB Mapping template becomes active.

Asset Attribute

The Asset Attribute column lists all the attribute fields of the selected Asset Category that can be mapped to the CMDB attributes.

Asset Attribute Type

This column lists the Asset Attribute Type as Dynamic or Static.

Mapping Column

This column lists all the attributes of the selected CMDB Classification value that needs to be mapped with the required Asset Category attributes. Select a value from the drop-down list. The selected drop-down value from the CMDB is mapped to the Asset attribute.

Figure: Configure Conditions 

Field Description

This table describes the fields available on the CONFIGURE CONDITIONS page.

Field

Description

Row

Display the Row number.

AND/OR:

 

Click the AND tab to add the Condition using the AND operand for the selected Attributes. If the AND operand is selected, all the Conditions defined under it should be met to implement the Action. Click the OR tab to add the Condition using the OR operand for the selected Attributes. If the OR operand is used, at least one of the Conditions defined under it should be met to implement the Action.

To add conditions:

Select the Attribute Name for which you want to configure the condition from the list. Choose the Operator from the list. Type in the Attribute Value you want to equate with the Condition. 

Attribute Name

Select the Attribute Name from the drop-down list.

Operator

Select the Operator type from the drop-down list. The available Operators types are =, <>, >, <, >=, <=, In, Not In, Like, Not Like, and Between.

Attribute Value


Based on the selection in the Operator field, the Attribute value may be a text box field where the user should enter some values. Or, it may be a drop-down list, where the user needs to select values. Or, it may be a date format, where the user is expected to specify the From and To dates.

Action

Display the Action type.

  • Click  icon to add another row of Condition.
  • Click  icon to delete the configured Condition.

NEXT

Click NEXT to navigate to the main page (CMDB MAPPING).

DELETE & CLOSE

Click DELETE & CLOSE to delete the conditions and navigate to the main page (CMDB MAPPING page).

RESET

Click Reset to reset the conditions to the initially configured condition for the selected template.

Note:

Data synchronization is implemented if the Enable Hardware Variance Sync and Enable Software Variance Sync check boxes are selected on the APPLICATION SETTINGS BY TENANT page. For more information, see the Configuring Asset Application Settings.

ACTIONS

This section explains the all icon displayed on the ACTIONS panel of the CMDB MAPPING page.

SHOW LIST

Click SHOW LIST to display the LIST table showing the CMDB Mapping templates that are configured for the selected Tenant.

CMDB MAPPING - LIST page
Figure: CMDB MAPPING - LIST page

Note:

  • On the LIST page, no value is displayed for the Store field if the Import Type is configured as Asset to CI Import on the selected template.

  • On the LIST page, no value is displayed for Owner workgroup, Owner, Customer, and Criticality field if the Import Type is configured as CI to Asset Import on the selected template.

Filters

This icon is used to specify the filter criteria to display the CMDB Mapping templates. On clicking the Filters icon, the FILTERS pop-up page is displayed. Specify the filter criteria and click SUBMIT. For more details on the filter fields, see Field Description.

Filter pop-up page
Figure: Filter pop-up page


Field Description

The following table describes the fields on the FILTERS pop-up page:

Field

Description

Tenant

Select the Tenant from the list. The CMDB Mapping templates associated with the selected Tenant are displayed.

Template Name

Type in the Template name that you want to view.

Asset Category

Select the Asset Category. All the CMDB Mapping templates to which the selected Asset Category is mapped are displayed in the list.

CMDB Classification

Select the CMDB Classification. All the CMDB Mapping templates to which the selected CMDB Classification is mapped are displayed in the list.

Import Type

Select the Import Type as Asset to CI Import or CI To Asset Import.

ADD NEW

When the CMDB Mapping templates list is displayed under the LIST table, the ADD NEW button is displayed on the ACTIONS panel. Click ADD NEW to configure a new CMDB Mapping template.

PRINT

Click PRINT to generate the print of the records available on the current page.

EXPORT TO EXCEL

Click EXPORT TO EXCEL to export the CMDB Mapping List to a Microsoft Excel sheet. 

EXPORT ALL

Click EXPORT ALL to export all the CMDB Mapping details to a Microsoft Excel sheet.