Move child table field data to parent table

[_bhishek]

Hi All,

We have 'end of life' field in cmdb_ci_hardware table  and it has 5500 records which are having that field filled .I want to move this field to cmdb_ci without losing data.So that I can use that field under Asset-CI mapping table .Please suggest me .

Also how can i confirm ,is there any script or some thing is using this field .So that it should not impact anything .I have checked BRs,Client scripts and SIs,There is nothing related to this field.

Please let me know if you need any other information.

Thanks.

[Simon Christens]

Hi

Check out this post

https://www.servicenowguru.com/scripting/promote-field-extended-table-servicenow/

I only recommend that you do this with custom fields but it works

[_bhishek]

Hi Simon,

As i have  read in service now Documents ,We should not use these function in CMDB tables to promote fields .I have used this function for alm_hardware table and it is promoted.

Thanks.

[_bhishek]

Thank you all.For your responses .

I have completed the requirement.

[pvvn]

Hi Abhishek,

I too have same requirement for cmdb_ci_server table column moving to cmdb_ci table.
Can you please let me know how have you performed the  task.

Thanks

Varahalu.