Table: zoom_user - Query Zoom Users using SQL

Zoom is a cloud-based video communications app that allows you to set up virtual video and audio conferencing, webinars, live chats, screen-sharing, and other collaborative capabilities. Users are the individuals who have registered by providing their email, name, and other personal information to use this platform. Zoom provides a comprehensive set of user management features, including user roles, statuses, settings, and more.

Table Usage Guide

The zoom_user table provides insights into user management within Zoom. As an IT admin, explore user-specific details through this table, including email, first name, last name, and status. Utilize it to uncover information about users, such as their roles, statuses, settings, and the verification of their profiles.

Examples

List all users

Explore all registered users within your Zoom account to ensure proper management and oversight. This can be particularly useful for administrators seeking a comprehensive overview of all account users.

select
  *
from
  zoom_user;

select
  *
from
  zoom_user;

Get a user by ID

Explore the details of a specific user in the Zoom platform. This is particularly useful when you need to assess user-related issues or understand their activity within the system.

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

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

Get a user by email

Discover the details of a specific user in your Zoom account by using their email address. This can be particularly useful for administrators who need to manage or track user activities.

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

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

Most recently created users

Discover the most recent additions to your Zoom user base. This query helps you keep track of new users, allowing for timely onboarding and account management.

select
  *
from
  zoom_user
order by
  created_at desc
limit
  5;

select
  *
from
  zoom_user
order by
  created_at desc
limit
  5;

Users by license type

Discover the segments that are most common among Zoom users based on their license type. This can help prioritize resources and tailor services for the most prevalent user categories.

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

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

Schema for zoom_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_id	text		Zoom account ID.
cms_user_id	text		CMS ID of user, only enabled for Kaltura integration.
company	text		User's company.
created_at	timestamp with time zone		The time when user's account was created.
custom_attributes	jsonb		Custom attributes, if any are assigned.
dept	text		Department, if provided by the user.
email	text	=	User's email address.
first_name	text		User's first name.
group_ids	jsonb		IDs of groups where the user is a member.
host_key	text		The host key of the user.
id	text	=	User ID.
im_group_ids	jsonb		IDs of IM directory groups where the user is a member.
jid	text		User's JID.
job_title	text		User's job title.
language	text		Default language for the Zoom Web Portal.
last_client_version	text		The last client version that user used to login.
last_login_time	timestamp with time zone		User'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_name	text		User's last name.
location	text		User's location.
login_type	bigint		Login type. 0 - Facebook, 1 - Google, 99 - API, 100 - ZOOM, 101 - SSO
personal_meeting_url	text		User's personal meeting url.
phone_numbers	jsonb		User phone number, including verification status.
pic_url	text		The URL for user's profile picture.
plan_united_type	text		This field is returned if the user is enrolled in the Zoom United plan.
pmi	bigint		Personal meeting ID of the user.
role_id	text		Unique identifier of the role assigned to the user.
status	text		User's status: pending, active or inactive.
timezone	text		The time zone of the user.
type	bigint		User's plan type: 1 - Basic, 2 - Licensed or 3 - On-prem.
use_pmi	boolean		Use Personal Meeting ID for instant meetings.
vanity_url	text		Personal meeting room URL, if the user has one.
verified	bigint		Display whether the user's email address for the Zoom account is verified or not. 1 - Verified user email. 0 - User's email not verified.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- zoom

You can pass the configuration to the command with the --config argument:

steampipe_export_zoom --config '<your_config>' zoom_user