Need Help: Mapping Assignment Group Values to Group Names and Filtering Change Requests

[ChaimaM]

Hi ServiceNow Community,

I’m currently facing an issue while working with change requests and groups in ServiceNow. Here’s a breakdown of the problem:

1. Issue with Assignment Groups in Change Requests:
   When I retrieve change requests, the assignment_group field shows a value (what appears to be a sys_id) instead of the name of the group. For example, I see something like 1234567890abcdef1234567890abcdef instead of the actual group name like "XYZ_Support_Team".

2. Mismatch Between Group IDs and Assignment Group Values:
   When I retrieve the list of groups (using the sys_user_group table), I see the sys_id and name fields. However, the sys_id values in the group list do not match the assignment_group values in the change requests. This makes it difficult to map the assignment groups to their corresponding group names.

3. Goal:
   I need to filter and sort change requests based on a specific parameter: groups whose names start with certain characters (e.g., "XYZ"). However, since the assignment_group field only shows a value and not the group name, I’m unable to directly filter the change requests based on group names.

What I’ve Tried:

• I’ve queried the change_request table to retrieve assignment_group values.

• I’ve queried the sys_user_group table to retrieve group sys_id and name fields.

• I’ve attempted to compare the assignment_group values with the sys_id values, but they don’t match.

Questions:

1. Is there a way to retrieve the group name directly in the change_request table instead of the assignment_group value?

2. How can I map the assignment_group values to their corresponding group names?

3. Is there a better way to filter change requests based on group names that start with specific characters (e.g., "XYZ")?

Any guidance, scripts, or suggestions would be greatly appreciated! Thank you in advance for your help.