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.
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.
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
