GroupUsers
Query the groups created in your account and the users that are associated with the groups.
Table Specific Information
Select
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'
Columns
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. |