CMDB business criticality

[Ballela Siva Te]

Hi Team,

We have a field called business criticality on CMDB_ci table. since table has many child tables configurations are made over dictionary and the choices for business criticality was not in sink. Please see the image below

Now they are requesting the choices to be same for all child tables. Can you please help me how can this be done (only 5 choices)

[Mark Manders]

This will be a huge undertaking. Simply because the choices are all there at this moment. What is this field used for? Is it for reporting, is it used in integrations? 

Assuming 1 - 5 on top level, will still need to apply on all the child tables (so if it's 3 on cmdb_ci_computer now, it's still 3 when it comes from the top), you can inactivate all choices on the child tables and make sure the only active ones are on the CMDB_CI table. After that, run a fix script to update all choices to the active choice with the same value. Depending on the number of CI's, you may want to run this in batches.