With AssetTrack, ServiceNow customers can now streamline asset lifecycle tracking using AssetTrack's enterprise-class barcode and RFID tracking solution. This includes receiving, IMAC, retirement, physical inventory & audit functions using smartphones, scanners, RFID readers, spreadsheets and a programming API.
The AssetTrack ServiceNow integration requires an instance of AssetTrack Server, which is licensed from AMI. Contact sales@amitracks.com for a quote. The integration is easily added to an existing AssetTrack installation version 3.6 or greater by applying a new license key. Customers on previous versions must upgrade to version 3.6 before the ServiceNow integration module can be installed.
AssetTrack integrates with ServiceNow using the ServiceNow JSON Web Service. Data flows to ServiceNow through a certified integration which you must install on your ServiceNot Eureka or Fuji instance.
AssetTrack integrates out-of-box with ServiceNow version Eureka or later
You can purchase the AssetTrack ServiceNow application here. You can click the Buy button in the top right corner and then you will need to enter in your HI portal credentials. Once you have finished buying the AssetTrack application you can go to your ServiceNow instance to insall.
Go to your ServiceNow instance at <instance>.service-now.com. To install the AssetTrack application follow the following steps.
You need to make a few configuration changes to your ServiceNow instance after you install the AssetTrack Certified Integration.
Then, you need to make a few configuration updates to your AssetTrack Server so that it can connect to your ServiceNow instance.
Download the preprocessor and handler configuration files from AMI.
Go to the settings page of your AssetTrack server.
There are two ServiceNow specific JSON formatted configuration files that need to be imported into AssetTrack, click the following links to download. The preprocessor config defines what information to bring down from ServiceNow and how to map it into AssetTrack.
The preprocessor config has the following format:
You must edit the BaseUri to be your instance of ServiceNow.
{ "BaseUri": "https://instance.service-now.com/", "TableMaps": [ { "TableName": "core_company", "FisFileName": "Vendor", "QueryFilter": "vendor=true", "RecordCount": 1000, "ColumnMaps": [ { "SourceColumn": "sys_id", "DestinationColumn": "ExternalId", "Regex": null }, { "SourceColumn": "name", "DestinationColumn": "Name", "Regex": null } ] }, { "TableName": "cmn_location", "FisFileName": "Location", "QueryFilter": null, "RecordCount": 1000, "ColumnMaps": [ { "SourceColumn": "parent", "DestinationColumn": "ParentExternalId", "Regex": null }, { "SourceColumn": "sys_id", "DestinationColumn": "ExternalId", "Regex": null }, { "SourceColumn": "name", "DestinationColumn": "Name", "Regex": null } ] }] } |
Property Definitions:
In 4.11 we added the SourceColumns, SourceColumnsOutput and OutputSeparator property to support concatenating multiple source fields into a single AssetTrack field.
Example:
SourceColumns: ["city", "state"]
SourceColumnsOutput: "{0}, {1}"
Would result with:
Location name: Howell, Michigan
Example:
SourceColumns: ["city", "state"]
SourceColumnsOutput: "{1}, {0}"
Would result with:
Location name: Michigan, Howell
Example:
SourceColumns: ["city", "state"]
SourceColumnsOutput: "{1}_ {0}"
Would result with:
Location name: Michigan_ Howell
Default values are joined by " - " if SourceColumnsOutput is not specified. The default separator can be overridden with OutputSeparator.
Example:
SourceColumns: ["city", "state"]
OutputSeparator: "_"
Would result with:
Location name: Howell_ Michigan
To set up AssetTrack for ServiceNow you must go to your AssetTrack server webpage, and go to your settings page. On the main screen of the settings page, scroll down to Integration Settings and set Repository integration to Tabular Files.
After that is set click on the ServiceNow tab on the left hand side of the screen. Here you will need to enter the AssetTrack user name and password you created in the steps earlier. Set your ServiceNow endpoint to be your ServiceNow instance. Next, you can upload your edited preprocessor and proper handler config file to the AssetTrack server.
Mapping files allow you to change how fields in AssetTrack map to fields in ServiceNow. If you haven't made many modifications ot the ServiceNow schema, simply use the default mapping files provided below.
After you downloaded the proper mapping file, go to the ServiceNow settings page on your AssetTrack server website. Under ServiceNow Mapping, browse for your mapping file and upload it to the AssetTrack server.
If you are using a proxy to connect to your Fuji ServiceNow instance, you must download the file, Fuji Default Mapping File - With Proxy Settings, and edit all properties under the property named, "proxy". If your proxy does not require credentials, you can delete that section entirely. |
Configuring Forms to Connect to ServiceNow
When making or configuring your AssetTrack forms you must attach the correct handler to your forms on the form designer in the Management Console, for more information see Attaching Handlers . Once in the form designer under publishing you can add the ServiceNow App Task Handler to your forms shown below.
After the handler has been added, select it in the Registered Handlers window and below that a Handler settings box will populate. There you must select the mapping handler that you uploaded to the AssetTrack server.