turbot/zoom

GitHub
steampipe plugin install zoomsteampipe plugin install zoom

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.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextZoom account ID.
departmenttextDepartment of the member.
emailtextEmail of the member.
first_nametextFirst name of the member.
last_nametextLast name of the member.
role_idtextRole ID.
typetextType of the member.
user_idtextUser ID of the member.