Creating Sub Groups

[Ryan153]

In our implementation of ServiceNow user group hierarchy was not implemented, and thus is causing me some issues with dashboard filtering. 

Case: I want to be able to present a dashboard under a 'Tier n' group (manually defined) and then be able to select the actual user groups.

Ex:

sys_user_group

• Service Desk A
• Service Desk B
• Service Desk C
• Service Desk D
• Service Desk E

Desired representation in the dashboard

• Tier 1
• • Service Desk A
  • Service Desk B
• Tier 2
• • Service Desk C
• Tier 3 
• • Service Desk D
  • Service Desk E

When the user loads the Dashboard they would be able to select 'Tier n' and then have the appropriate Service Desks as an additional filter.

Thanks for reading and responding.

[sachin_namjoshi]

You can make use of "parent" field on sys_user_group table.

e.g Tier 1 will be parent group for service desk A and service desk B groups

Tier 1

• • Service Desk A
  • Service Desk B

Then, you can configure interactive filter on your dashboard to filter data based on child service desk groups.

Regards,

Sachin

[Ryan153]

Thank you for your reply Sachin.  Unfortunately the reason I am posing this question is because I am unable to modify the parent/child relationships within the sys_user_group table and need to look at other options to facilitate this type of filtering. 

[SusanWinKY]

Ryan, we have this same requirement and were able to handle it with cascading filters, but we had to create a custom table and a custom field to do so.  If you're unable to modify the parent/child relationships on groups, you may not be able to do this either, but I thought I'd mention it.

In our case, we wanted to specify a "Tower" for each group (application management, network management, desktop support, data center, service desk, etc.).  Our process was to create the "Tower" custom table and populate it with the values we need.  Then on the group table, we added a custom "Tower" field that references that new table.  We then updated the relevant groups with a value for the Tower.  Then we created the interactive filter (see instructions in link above).

Hope this is helpful.