Populate CMDB Serial Number table through import set/integration hub ETL

[RahulY00040]

Hello friends,

I would like to know how to populate the cmdb_serial_number table using ServiceNow import set. We have an integration using transform map and want to know how to create an entry in cmdb_serial_number table. Should I create this entry in onAfter or expect IRE to do this?

Also, how these entries are populated through Service Graph Connectors or Integration HUB-ETL.

Thanks in advance,

Rahul

[k_lutz]

Hello @RahulY00040 

if you are going to stay with the transform map then you would want to look at how to use the "CMDBTransformUtil" script include and related functions in your logic.

If you are using a connector it is built into the logic. See screenshot below that is from a JAMF where it shows the cmdb_serial_number and fields that get populated.

[RahulY00040]

Hello @k_lutz , I dont think that CMDBTransformUtil will help me in creation of Serial Number table records populated., in connector/SGC as you mentioned in screenshot, its being explicitly mapped to cmdb_serial_number table by creating the Entities in RTE. 

In import set, I think i need to explicitly to do On After script to populate serial number table. Let me know if you have contracting thoughts.

Thanks,

Rahul

[k_lutz]

Hi @RahulY00040 

You are correct. I went back to look at one of the transform maps I worked on before and I first use the script include above to make sure it goes through the IRE so it gets created or updated as needed. Then I have a final onAfter script where I check the cmdb_serial_number table to see if a record exists or not. If that serial number is not found I create a "system". I think we picked that "type" after looking at other devices created by automated systems and thought it was the most appropriate entry...so you may want to research the proper one for your case. The hope we have in some of these is that we will eventually get a feed or true discovery source that will keep them updated properly.

[RahulY00040]

Thanks for your response. Could you please elaborate more on "If that serial number is not found I create a "system".". What do you mean by create a "System" user.

Thanks,

Rahul