How do I bulk update Managed by Group on cmdb_ci_info?

[Ken K1]

My understanding is that the cmdb_ci_info table contains Managed by Group field for the CI classes.   I know how to use the Easy Import as well as Data Load/Transform.  

When I open the cmdb_ci_info table, only 94 classes are listed, but if I run a script to show me all the classes that have data against them, I see ~1200 tables.   

I have been able to identify groups to align to these 1200 tables.   We will address the non-populated tables in a second round for the "what if they get populated" conditions.

How can I bulk update all of the classes when only 94 are listed?  Or is there another table that I am not aware of?

[emir]

• Managed by Group: Enables you to automatically identify the group responsible for managing the details of a CI. Within the CI Class Manager, you can now identify the Managed by Group field for CIs on a class-by-class basis. All CIs within a class will have their Managed by Group field populated based on the value specified in the CI Class Manager. Also, for those CIs that are managed by a Technical Service Offering, the Managed by Group field is first synchronized with its dynamic CI group. This field is then synchronized with the CIs that are part of that dynamic CI group, overwriting the entry from the CI Class Manager.

If you only see 94 then only 94 are defined. 

Keep in mind, if it is defined at cmdb_ci_hardware level then all of its descendents will inherit it to0l, example Linux Server

[Ken K1]

I am aware of the purpose.  This answer does not adequately represent what I am seeing.  If I list the 94 items, they all show Managed by Group as (empty).   If I look inside the CI Class Manager, I can see that every class has the ability to set that attribute.  I am trying to determine the proper way to set these in bulk since all the classes are not listed in the 'info' table.   I am aware of the inheritance, however, as a large organization we have different groups support different technologies based on platform.  For instance, windows server support for windows servers vs unix engineering for *nix based operating systems.  So I will need to set things more discretely.  

I think we understand how we can best apply these based on this video which does a very good job of distinguishing between managed by group, change group, and support group.

https://youtu.be/MECwnUCf6ac