CMDB Automate assignment group apart from CI class manager support group

[Sohail Khilji]

Lets assume there are 3 groups GroupA , GroupB , GroupC

Each Group has diffrent CIs owned as below.

GroupA >  10Windows Servers, 5 Linux Server, 1 Storage Servers , 12VMs

GroupB >  11Windows Servers, 15 Linux Server, 4 Storage Servers , 32VMs

GroupC >  22Windows Servers, 3 Linux Server, 3 Storage Servers , 52VMs

I.e. Each group is owning multiple devices.

Question :

How do i set the Assignemt group for each devices automatically  ? Iam aware of CI class manager field which sets support group based on class. But here the condition is each group owns CIs from diffrent class. How can i manage to get the Support or Assignmet group for all CIs in my CMDB. ?

how is it automated or managed in any given environment ?

@Runjay Patel @Brad Bowman  @Ravi Chandra_K 

[Runjay Patel]

Hi @Sohail Khilji ,

You can use base table (cmdb_ci) and do gliderecord based on sysid of CI to get the support group.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[subhadeep1618]

Hi @Sohail Khilji 

The cmdb_ci table has a field called Support group (support_group).

For each device or CI, you need to update this field's value to either Group A, B or C.

e.g. 

GroupA >  10Windows Servers, 5 Linux Server, 1 Storage Servers , 12VMs

You need to update the support_group of these 28 CI records to GroupA.

Then you have to write a client-side script or business rule in the table where you want to assign the group.

In the script you need to query the support_group value, and set it as the Assignment Group when the end user selects the corresponding CI.

If you need help with the script - please let me know.