Business Adapter Mappings

IT Asset Management (Cloud)

Two business adapters are supplied as a standard part of the ServiceNow integration application for IT Asset Management, and are used in the process of transferred asset and contract data from ServiceNow to IT Asset Management. The following lists show the source data from ServiceNow, and the target (destination) fields in IT Asset Management, for each of these adapters in turn.

Tip: For special purposes, mappings can be added, removed, or changed by editing the business adapter(s) in Business Adapter Studio on your inventory beacon.

In each listing, the first field shown is used for matching existing records (a key). During import, if the value in this field already exists in the compliance database, the record is updated with the other values imported for this item. Otherwise, a new record is automatically created in IT Asset Management.

In both listings below, "display" names are the names visible in the two products' web interfaces; and the Source Field column shows a compound name made up of:

• An abbreviated reference to a ServiceNow database table name (see below)
• An underscore character
• The field name in the relevant database table (which name may contain additional underscores).

The mapping of the abbreviated references to the actual database table names in the ServiceNow database is:

• acntrct represents ast_contract
• ahrdwr represents alm_hardware
• cicomp represents cmdb_ci_computer
• cmdbmdl represents cmdb_model
• sysusr represents sys_user.

Assets Imports

• Business adapter file name: ServiceNowAssets.xml
• Original data source: ServiceNow database view x_fls_flexera_fnms_asset
• Destination table in IT Asset Management database: Asset

Source Display Name	Source Field	Target Display Name	Target Field
Serial number	cicomp_serial_number	Serial Number	SerialNumber (key)
Asset tag	ahrdwr_ asset_tag	Asset Tag	AssetTag
Asset Status	ahrdwr_install_status	Asset Status	AssetStatus
Configuration Item	ahrdwr_ci	Name	ShortDescription
Installed	cicomp_install_date	Installed on	InstallationDate
Manufacturer	cicomp_manufacturer	Manufacturer	Manufacturer
ModelNo	cicomp_model_number	ModelNo	ModelNo

Notes:

1. AssetStatusID is a foreign key to the AssetStatus table, from which display values are drawn.

Note: AssetStatus is a mandatory field for asset records in IT Asset Management. The out of the box business adapter does explicit mapping between ServiceNow Status values and IT Asset Management AssetStatus values, as shown in the following table. If needed, you can modify these mappings in the business adapter or if you have custom mappings defined in ServiceNow, you must include them here. Note that if you are also 'round-tripping' this data (that is, copying it back from to ServiceNow at some future point, to maintain synchronization), you need to provide a similar mapping in the relevant transform map as well.

ServiceNow	IT Asset Management
On order	Purchased
In stock	In Storage
In transit	Purchased
In use	Installed
Consumed	Installed
In maintenance	Other
Retired	Retired
Missing	Other

Contracts Imports

• Business adapter file name: ServiceNowContracts.xml
• Original data source: ServiceNow database view x_fls_flexera_fnms_contract
• Destination table in IT Asset Management database: Contract

Source Display Name	Source Field	Target Display Name	Target Field
Contract number	acntrct_vendor_ contract	Contract Number	ContractNo (key)
Description	acntrct_description	Information	Comments
Display name	cmdbmdl_display_name	Contract type	ContractTypeID [Note 1]
Ends	acntrct_ends	Expiry date	EndDate
Short description	acntrct_short_description	Contract Name	ContractName
Starts	acntrct_starts	Start date	StartDate
State	acntrct_state	Status	ContractStatusID [Note 2]

Notes:

1. ContractTypeID is a foreign key to the ContractType table, from which display values are drawn. Also see note below.
2. ContractStatusID is a foreign key to the ContractStatus table, from which display values are drawn.

Note: ContractTypeID is a mandatory field for contract records in IT Asset Management. If a record in ServiceNow has a Display name value that does not exist in IT Asset Management, the record is imported with the contract type General. To work around this type change, you can modify the business adapter to provide an explicit mapping between ServiceNow Display name values and IT Asset Management ContractTypeID values. Note that if you are also 'round-tripping' this data (that is, copying it back from IT Asset Management to ServiceNow at some future point, to maintain synchronization), you need to provide a similar mapping in the relevant transform map as well.