Assignment group details for an individual user

[GaneshErike]

Hi,

We are exporting user details from user table to excel sheet.

But we are unable to get Assignment Group details to which the user is part of.

Assignment Group is a related list in the user form, so we are unable to get that details while we are exporting user details.

Is there any possibility to get Assignment Group details for every user in a excel sheet.

Thanks in advance.

[Ankur Bawiskar · Accepted solution]

@GaneshErike 

user data is stored in sys_user and that table doesn't hold Group data.

you can use sys_user_grmember and this will tell User is part of which group

If my response helped please mark it correct and close the thread so that it benefits future readers.