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_member
where
  role_id = '0'

List all members of all roles

select
  r.id,
  r.name,
  m.user_id,
  m.first_name,
  m.last_name
from
  zoom_role as r,
  zoom_role_member as m
where
  r.id = m.role_id
order by
  r.name,
  m.first_name,
  m.last_name

List all roles that have dwight@dundermifflin.com as a member

select
  r.id,
  r.name
from
  zoom_role as r,
  zoom_role_member as m
where
  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.
email	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.

turbot/zoom

Table: zoom_role_member

Examples

List all Owners in the account

List all members of all roles

List all roles that have dwight@dundermifflin.com as a member

.inspect zoom_role_member

Steampipe

Resources

Community