report users in groups

osvaldo2
Kilo Contributor

Is there a report that will show you the groups in your instance along with the users within the groups?

5 REPLIES 5

sachin_namjoshi
Kilo Patron
Kilo Patron

Hi,



You can report on sys_user_grmember table to find users and groups.



sys_user_grmember.LIST



Regards,


Sachin


Thanks. Let me see if this is what is needed.


Hello osvaldo,



As mentioned by Sachin, you should be able to report on table sys_user_grmembership as this holds user to group relationship.



Reference:


Reporting on System Tables - ServiceNow Wiki


Reporting



Please let us know if you are blocked.


Thank you @sachin_namjoshi ! Had the same query and this was a KBA thingy for me.