CMDB CI tables model and category import

[Katie A]

Hello,

I am in the process of importing data from SCCM to populate our CMDB tables.

How can I properly populate new Model and Model Category values when they do not exist already in the system?

I took the asset management class and we were provided with a script for importing data into asset tables alm*.

The issue is that I am importing records into an import set and then transforming the records directly into the CMDB_CI_Computer table. I am not importing directly to the ALM tables. I will be assigning a Model to each record and the Model Category will create the asset if necessary.

How can I populate the model and model categories from the import into the CMDB directly?

How can I differentiate between computer hardware and virtual machines such that they can be imported into the proper model category classes?

Thanks!

[Katie A]

I have written a script include that is called by the Transform Map > Field Map > Source Script.

The script takes the model name as an input, searches the cmdb_model table, and if it does not find a match it will create a new record in that table and then return the sys_id of the new model record as the answer. This seems to work OK. I have some hard-coded values to set the Model Category.

Has anyone tried any different approaches for this requirement?

Thanks,