How to JOIN sys_user & sys_user_grmember tables

stevezadroga · ‎06-29-2019

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?

Prateek kumar · ‎06-30-2019

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

stevezadroga · ‎07-01-2019

Dirk,

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