GroupUsers

Query the groups created in your account and the users that are associated with the groups.

Table Specific Information

Retrieve all the groups of your account and all the users in each group

SELECT * FROM GroupUsers

You can also retrieve all users that belong to one group

SELECT * FROM GroupUsers WHERE GroupId='123'

Name	Type	References	Description
GroupId [KEY]	Integer		The unique identifier of the group.
GroupName	String		The name of the group.
UserId [KEY]	Integer		Id of the user belonging to the group.
Username	String		Name of the user belonging to the group.
UserEmailAddress	String		Name of the user belonging to the group.