Support groups

[geoitsms]

Hi,

Can anyone tell me if there is the ability in SNow to not only show the support group names in my report but also any users in the groups?

Thanks

[rgm276]

Yes,

Here is a group membership report we use

[geoitsms]

Thanks much Robert...looks like it would work but since we are a fairly new SN environment, I don't have the sys_user table built.

[peterwestergaar]

George, I'm confident that you certainly do have both sys_user and sys_user_grmember

Those are both critical core tables, sys_user is where the users are recorded, and sys_user_grmember is where membership of users in different groups is recorded.      

If I had a user "abigail" in five groups, there would be five records in sys_user_grmember for user "abigail", one for each group.  

[peterwestergaar]

To check the existence of those tables, go to the search bar at the top of the sidebar, where it says "Type Filter Text", and enter:

• sys_user.list
• sys_user_grmember.list

Don't type "ENTER" after you finish typing, just let the screen load after you hit the 't' in the word 'list'.   You should be taken to a view of the data in that table.   Presto!