turbot/zoom

steampipe plugin install zoomsteampipe plugin install zoom

Table: zoom_user

Query information about users in the Zoom account.

Examples

List all users

select
*
from
zoom_user

Get a user by ID

select
*
from
zoom_user
where
id = 'RCKlotFLRpe-Hbnv-VK3CA'

Get a user by email

select
*
from
zoom_user
where
email = 'dwight@dundermifflin.com'

Most recently created users

select
*
from
zoom_user
order by
created_at desc
limit 5

Users by license type

select
type,
count(*)
from
zoom_user
group by
type
order by
count desc

Users with Security:Edit permission

select
*
from
zoom_user
where
permissions ? 'Security:Edit'

.inspect zoom_user

A Zoom account can have one or more users.

NameTypeDescription
account_idtextZoom account ID.
cms_user_idtextCMS ID of user, only enabled for Kaltura integration.
companytextUser's company.
created_attimestamp without time zoneThe time when user's account was created.
custom_attributesjsonbCustom attributes, if any are assigned.
depttextDepartment, if provided by the user.
emailtextUser's email address.
first_nametextUser's first name.
group_idsjsonbIDs of groups where the user is a member.
host_keytextThe host key of the user.
idtextUser ID.
im_group_idsjsonbIDs of IM directory groups where the user is a member.
jidtextUser's JID.
job_titletextUser's job title.
languagetextDefault language for the Zoom Web Portal.
last_client_versiontextThe last client version that user used to login.
last_login_timetimestamp without time zoneUser's last login time. There is a three-days buffer period for this field. For example, if user first logged in on 2020-01-01 and then logged out and logged in on 2020-01-02, the value of this field will still reflect the login time of 2020-01-01. However, if the user logs in on 2020-01-04, the value of this field will reflect the corresponding login time since it exceeds the three-day buffer period.
last_nametextUser's last name.
locationtextUser's location.
login_typebigintLogin type. 0 - Facebook, 1 - Google, 99 - API, 100 - ZOOM, 101 - SSO
personal_meeting_urltextUser's personal meeting url.
phone_numbersjsonbUser phone number, including verification status.
pic_urltextThe URL for user's profile picture.
plan_united_typetextThis field is returned if the user is enrolled in the Zoom United plan.
pmibigintPersonal meeting ID of the user.
role_idtextUnique identifier of the role assigned to the user.
statustextUser's status: pending, active or inactive.
timezonetextThe time zone of the user.
typebigintUser's plan type: 1 - Basic, 2 - Licensed or 3 - On-prem.
use_pmibooleanUse Personal Meeting ID for instant meetings.
vanity_urltextPersonal meeting room URL, if the user has one.
verifiedbigintDisplay whether the user's email address for the Zoom account is verified or not. 1 - Verified user email. 0 - User's email not verified.