question How to bulk import assets into an existing Maintenance contract in ServiceNow in SAM forum

How to bulk import assets into an existing Maintenance contract in ServiceNow

Miza Oliva — Wed, 02 Sep 2020 20:58:40 GMT

Hi ... what would be the best approach to bulk importing assets for an existing Maintenance Contract? Is the a template I should use? If yes, can someone share? I have about 500 assets I need to add to a maintenance contract and I dont think I should have to do that 1 at a time. I have all the serial numbers for the devices and they all exist in servicenow.

Re: How to bulk import assets into an existing Maintenance contract in ServiceNow

Daniel Slocum — Wed, 02 Sep 2020 23:36:22 GMT

Hi Miza,

The simplest method is to use an import set and coalesce on the Serial Number or the Asset Tag of the Assets to be added and the Contract Number of the contract they will be related to. The destination table is "clm_m2m_contract_asset". Your ServiceNow Admin should be able to assist you with this. To get a jump on the effort you can start by creating a spreadsheet containing the values I've mentioned above. A mock up of the spreadsheet is in the table below using the Asset Tag for asset identification. If you wish to use Serial Number, simply change the header and write unique serial number values to the column.

Contract Number	Asset Tag
CNTR0010023	AT100134
CNTR0010023	AT101289
CNTR0010023	AT123594
etc.	etc.

Re: How to bulk import assets into an existing Maintenance contract in ServiceNow

Stig Brandt — Thu, 03 Sep 2020 07:15:09 GMT

It is easier, just to use easy import, if this is a one time effort Go to list of asset covered, choose import, create template, add your data to excel sheet and do the upload/import. Cheers Stig