how to change change ci class for existing CIs

[Efra Pruneda]

we recently implemented hardware asset management and just realized that we mapped all our hardware models to the wrong category. we used the computer model category which is an OOB record. but this means that every asset created (alm_hardware) is creating a corresponding CI in the generic computer ci_class (cmdb_ci_computer). this is a problem because it is mixing laptops and desktops assigned to employees with all kinds of servers and other ci subclasses that are defined under computer in the ci hierarchy (according to the CI class manager).

the solution I found is to create a new model category record to tie all new assets (alm_hardware) to the cmdb_ci_pc_hardware ci class (personal computer). this worked for all new assets that will be created moving forward. but now I have several thousand assets that are tied to cis in the wrong ci_class. 

long story short, how can I change the ci_class for existing CIs and move them from the cndb_ci_computer to the cmdb_ci_pc_hardware class? of course, I will do this only for CIs that are related to records in the alm_hardware table.

I will greatly appreciate your help, thank you in advance

Efra

[Boyan1]

Hello, 

Can you please check below link:

https://docs.servicenow.com/bundle/quebec-servicenow-platform/page/product/configuration-management/task/t_ManuallyReclassifyCI.html

Best regards,

Boyan

[Efra Pruneda]

Boyan,

thank you so much for your reply. I think this is what I was looking for. but from reading this document I understand that reclassifying a CI will leave the original record where it is (in this case in the cmdb_ci_computer table) and then will create a second record in the new classification (cmdb_ci_pc_hardware). this is what the document calls an upgrade. but my concern is that the same CI will then have two different records in the CMDB, right? or will this process somehow make the original record inactive? otherwise searches in the cmdb by serial number will bring back two records.

thank you again for your help. please do let me know your thoughts.

Efra

[Boyan1 · Accepted solution]

Hello,

Actually, you will have only one record after the reclassification.

Best regards,

Boyan

[emir]

Your servers should be further classified (or at minimum marked as Servers), change your query to class is Computer to see laptops/Desktops only.

They are not in the wrong class as cmdb_ci_pc_hardware is a child of cmdb_ci_computer, just not as classified.