Table: zoom_role_member
Query information about members of a given role in the Zoom account.
Note: The role_id
field must be set in the where
clause.
Examples
List all Owners in the account
select *from zoom_role_memberwhere role_id = '0'
List all members of all roles
select r.id, r.name, m.user_id, m.first_name, m.last_namefrom zoom_role as r, zoom_role_member as mwhere r.id = m.role_idorder by r.name, m.first_name, m.last_name
List all roles that have dwight@dundermifflin.com as a member
select r.id, r.namefrom zoom_role as r, zoom_role_member as mwhere r.id = m.role_id and m.email = 'dwight@dundermifflin.com'order by r.name
.inspect zoom_role_member
Members of a Zoom role.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
account_id | text | Zoom account ID. |
department | text | Department of the member. |
text | Email of the member. | |
first_name | text | First name of the member. |
last_name | text | Last name of the member. |
role_id | text | Role ID. |
type | text | Type of the member. |
user_id | text | User ID of the member. |