Populate assigned to based on assignment group

[ceraulo]

Hello!

I have a catalog item that has 'assignment group' and 'assigned to' as variables. These are reference fields. I can populate the assignment group based on the client requirement. My problem is how to populate the assigned to reference field based on the assignment group. I think sys_user_grmember is needed to do this but I do not know how. 

Please help!

Thank you.

[Harsh Vardhan · Accepted solution]

yes you have to query on sys_user_grmember table, kindly have a look on below thread, it has mentioned script. 

https://community.servicenow.com/community?id=community_question&sys_id=65d147a9db98dbc01dcaf3231f96...

[ceraulo]

thank you so much

[Dhananjay Pawar]

Hi,

Just one quick question.

What if that single assignment group have multiple users?

Thanks,

Dhananjay.

[HS4]

Hi,

you can query assignment group table and find all the users of any assignment group.

Thanks,

Himani