How to import Hardware assets?

Sachin Nimbhork
Tera Contributor

Hi,

I would like to import bulk assets from excel into ServiceNow for which I have created Hardware Models. Now I am not sure which table I should use for importing it.

  1. Direct import on alm_hardware: If I will import data directly on alm_hardware table using import set option, I might ends up creating duplicate assets because we can't apply IRE rules on Asset table (my understanding) and we can't make serial number as coalesce (not a best practice to follow).
  2. Import on cmdb_ci_hardware: If I will use cmdb_ci_hardware to import data, then again I have to update asset specific attribute which is not their on cmdb table e.g. Acquisition Method.
  3.  Will there be any impact of selecting any of the above approach in implementing the SCCM integration in future (any duplicate Assets)? 

Regards,

Sachin

1 ACCEPTED SOLUTION

Daniel Slocum
ServiceNow Employee
ServiceNow Employee

Hello Sachin,

There is no issue with importing into alm_hardware while linking to the Hardware Model.  This is common practice.  If you do not have an Asset Tag, it is ok to coalesce on Serial Number.  In your transform map, you'd have a dual coalesce where you'd match on both the hardware model and the serial number.  While it is possible, it is very rare to have duplicate serial numbers within a product line. You should have no issues with this approach.

If your organization has a subscription to ServiceNow Discovery, you should consider use of the SCCM Service Graph connector instead of the SCCM Plugin.  The Service Graph integration for SCCM leverages the IRE to preclude duplicates. With the Paris release, 15 different Service Graph integrations were released to the ServiceNow Store.  You'll find the SCCM integration there for installation.  The guided setup in the integration will get you up and running with minimal effort. 

Daniel

View solution in original post

3 REPLIES 3

Daniel Slocum
ServiceNow Employee
ServiceNow Employee

Hello Sachin,

There is no issue with importing into alm_hardware while linking to the Hardware Model.  This is common practice.  If you do not have an Asset Tag, it is ok to coalesce on Serial Number.  In your transform map, you'd have a dual coalesce where you'd match on both the hardware model and the serial number.  While it is possible, it is very rare to have duplicate serial numbers within a product line. You should have no issues with this approach.

If your organization has a subscription to ServiceNow Discovery, you should consider use of the SCCM Service Graph connector instead of the SCCM Plugin.  The Service Graph integration for SCCM leverages the IRE to preclude duplicates. With the Paris release, 15 different Service Graph integrations were released to the ServiceNow Store.  You'll find the SCCM integration there for installation.  The guided setup in the integration will get you up and running with minimal effort. 

Daniel

Thanks Daniel,

Appreciate your response.

Manasa23
Tera Contributor

Hi Daniel,

We have a scenario, where we have both CMDB fields and Asset fields on staging table,

First we will have to update the CMDB fields then with the asset field on CMDB table, we will have to update .
the alm_hardware  table.

In transform map, we can run OnAfter script ..

1) Is it possible to write  OnAfter script on Service Graph (Robust transform map)
2) how to achieve this , what are the best practices to achieve this ..please let me know.

Thanks in Advance !!