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]

Hi Siddhesh,

You can create a separate transform map for Product model, That way you can create a separate coalesce field on Product model table to avoid duplicates.

I remember in one of the implementation, we have a separate transform map for the Product model table and later we link the existing product model record with the hardware record.

Hope it helps!!

Thanks for marking my response as correct.

[Siddhesh Gawade]

Hello @Sulabh Garg !!!

Thank you for reply

there is a one transform map for cmdb_hardware_product_model were in field mapping we coalesce model no. so when we transform same model with different configuration item we wanted to add this different CIs to get added in same product model. But beacause of coalesce they were getting updated(that mean latest Ci replaced to previous Ci). is there any way I can add all CIs which are related to same product model in Configuration item section?

Thank you!!!

Regards Siddhesh

[Sulabh Garg]

Just a thought, you can also perform coalesce on multiple fields too (model no and CI), That way it will check the combination of two field to be unique instead of one (model no).

[Siddhesh Gawade]

I wanted to add all Cis which are having same model no. under one product model.

As you suggested if I put multiple coalesce for (model no and CI) then it creates new record for diffrent Cis which are having same model no. that not how I wanted.

Thank you!!!

[Siddhesh Gawade]

Hello @Sulabh Garg ,

We have created a product model manually and now we use sys_id of the same product model. But the same model id with a different sys_id has been created under the Product Model. It shouldn’t have created a new model since we used the existing model ID.

when we use a unique serial number it will not create duplicate product models.

So I have a question does the serial number should be Unique every time?

Regards,

Siddhesh