How to avoid creating many transform maps or maybe automate it if not possible.

[Siddhesh Gawade]

We are creating ESX servers so we load data into cmdb_ci_esx_server class which in turn creates corresponding CI  and the asset. The same applies to the Server class (cmdb_ci_server) and other CI classes.  Though this approach is desirable and less error-prone, but it requires us to create transform maps of each class separately.    

So I want to be able to upload these asset using one transform map but it creating the assets on the windows server table or linux server table or computer peripheral table

When I put on the highest point of the table, we don't get any suggested parent- child relationship and CMDB just truly doesn't recognized it

Please guide and let me know how we can automate it and avoid creating many transform maps ?

Regards 

Siddhesh

[Sulabh Garg · Accepted solution]

Hello Siddhesh

One way I can think of to create field map of "Class" field (sys_class_name) where you can define the backend table name of each class, e.g: 'cmdb_ci_esx_server' or 'cmdb_ci_server' and this should present in your source file (csv or excel).

Using above approach you can build your transform on "cmdb_ci" table instead of individual class tables.

Hope it helps!!

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[Siddhesh Gawade]

@Sulabh Garg Thank you for your reply!!!

Can you please demonstrate how can I achieve this or elaborate more so I can try in my case.

Regards,

Siddhesh

[Sulabh Garg]

Please check this article for CMDB data transformation and refer #8 & #9 to see how you can create the field map for sys_class_name.

CMDB Data Integration

Other Community links to see how to update the class name through transform script is as below

How to update sys_class_name via Transform Map script?

Hope it helps!!

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[Siddhesh Gawade]

Thanks for your reply @Sulabh Garg 

I tried the way you suggested.

However, with that approach, product models are getting duplicated. . also I don't want to relying on the higher level (cmdb_ci) but on individual lower-level tables e.g. cmdb_ci_esx_server, or cmdb_ci_mfp_printer.

Is there any way I can do this?

Regards,

Siddhesh