Bulk Upload Asset and CI information

JohnMMcLaughlin
Tera Contributor

Hi,

The customer site I am working on doesn't currently use any form of discovery, the cmdb has been updated in the past by bulk upload via spreadsheet.

We are about to do the same again due a large laptop refresh, these are new assets (and ci's) that don't currently exist, when I upload the asset data a related CI is automatically created as it should be, however as we are going to do this import, I would like to bring in some CI data as well, in particular Form factor and OS.  Can I do this all via one spreadsheet, or is it going to have to be one import for asset data and then a second import for CI data?

 

Thanks in advance,

5 REPLIES 5

Alberto Consonn
ServiceNow Employee
ServiceNow Employee

Hi,

you have to do it using two different import set for the following separate tables:

  • Update Asset fields on the Asset [alm_asset] table
  • Update CI fields on the Configuration Item [cmdb_ci] table

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

johnfeist
Mega Sage
Mega Sage

Hi John,

When we started populating CMDB and Asset I was told that best practice is to load CMDB first.  This resulted in minimal Asset data being created as well.  We are using the SCCM connector so it is possible that one of the scripts is doing the population.  You might try doing a small upload to CMDB in a dev/persnoal instance to determine the right order for doing that load.

:{)

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

akash_mehta
ServiceNow Employee
ServiceNow Employee

John:   What kind of data are you populating in the asset?  The previous post about populating the CI (in this case cmdb_ci_computer) will result in the asset being created as well.  If some of the fields that will be populated also exist on the CI, then the sync process should populate both (also, same would be from  the asset to the CI as well).

The other possibility is to populate in the transform map as an  onAfter script.  You will need the target.ci  value and query the computer table.

Thanks for the reply.

 

We are concentrating on desktops, laptops, mobile and desk phones at the minute.

The data we are populating in the asset is: assigned_to, location, department, purchased date, po number, invoice number, lease number (if leased), status, stockroom, cost, request line, vendor, warranty expiration.

The data we are populating for the CI is: form factor, operating system.

 

As the majority of the data relates to the assets, we have decided to do a single bulk upload of assets and then manually update the CI's.

 

Do you happen to have an example of using a transform map and an onAfter script, as that may come in useful in the future?