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.

IT Asset Management (Cloud)

Current