CMDB business criticality

Ballela Siva Te
Tera Contributor

‎07-10-2024 10:52 PM

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

 

BallelaSivaTe_0-1720677061200.png

 

 

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)

0 Helpfuls
  • 1,877 Views
1 REPLY 1

Mark Manders
Tera Patron

‎07-11-2024 02:19 AM

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.

0 Helpfuls