How to JOIN sys_user & sys_user_grmember tables

Go to solution
stevezadroga
Tera Contributor

‎06-29-2019 06:43 AM

I am working with ServiceNow data with a third party reporting tool and trying to JOIN the sys_user & sys_user_grmember tables.  I want to return the group name, member name, member email, etc.  I was thinking of using the [name] field, but that is not unique.  Are there other keys I should be using?

Labels:
0 Helpfuls
  • 1,802 Views
1 ACCEPTED SOLUTION

Go to solution
Prateek kumar
Mega Sage
In response to stevezadroga

‎06-30-2019 08:12 AM

user field on the sys_user_grmember table is a reference field to sys_user table. It will return sys_id in the result.


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

View solution in original post

0 Helpfuls
5 REPLIES 5

Go to solution
stevezadroga
Tera Contributor

‎07-01-2019 06:20 AM

Dirk,

I am getting the data from ServiceNow leveraging the SOAP api and storing it in a MSSQL Server.

0 Helpfuls