How to move CI's from Personal Computer to Computer table

[janindiadoc_1]

Hi All,

I have got some some CI's in the Personal computer table (cmdb_ci_pc_hardware) table which has been mapped wrongly (CI class is personal computer). These CI's does not have an asset at this point of time (asset is empty). Ideally these CI's should be in the Computer table (cmdb_ci_computer). 

Can anyone advise the best way to move these CI's from personal computer to computer and create assets for those CI's in hardware asset table.

Thanks

[Daniel Borkowi1]

Hi @janindiadoc_1,

In my opinion that's because Personal Computers are in most companies not handled as Configuration Items, only as Assets - typically the configuration is outsourced. I don't think there is a deeper reason than that behind.

Greets
Daniel

Please mark reply as Helpful/Correct, if applicable. Thanks!

[janindiadoc_1]

Hi Daniel,

I tried manually classifying the CI from Personal Computer to Computer and that created assets in the asset table. I verified the sys_ids of old and classified CI and its the same. After reclassification there is only one record. 

Questions

-------------

1. If the CI is referenced in other records (for eg: incident, problem etc), will changing the class of the CI is a problem? I'm unable to verify the references of the CI's as it got a huge number of records to be reclassified.

2. What is the best approach to remove the duplicate assets? While verifying the data there are around 20 records in alm_asset table with the same CI name for some records. These records have just the configuration item name , nothing else is populated in the asset records.

Thank you,

Anjana

[Daniel Borkowi1]

Hi @janindiadoc_1 ,

1. as long as there is no Reference Qualifiers which filters out the new table, it should be no issue. Even there is a filter, the sys_id will stay in the reference field - therefore also the link to the CI. Only if you change the reference you will not see this CI anymore - but only if there is a Reference Qualifier filtering this out.

2. There is only a de-duplication engine available for CIs not for asset. I would try to write a fix script which search for duplicate assets with same name or other criterias like serial numbers and merge them (means choosing one main asset and switch all references to duplicates to the main asset) and then deleting the others. Maybe based on this approach https://www.jamesfarrer.com/?id=358.

Greets
Daniel

Please mark reply as Helpful/Correct, if applicable. Thanks!