Table: zoom_my_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. You can have up to 1,000 video participants and 10,000 viewers. Zoom is used by businesses for remote team meetings, webinars, demonstrations, virtual training, and more.

Table Usage Guide

The zoom_my_user table provides insights into user profiles within Zoom. As a system administrator, explore user-specific details through this table, including profile settings, account configurations, and associated metadata. Utilize it to uncover information about users, such as their role in the organization, their account status, and the configuration of their Zoom settings.

Examples

List user information

Explore the details of all user profiles within your Zoom account. This can help in managing users and understanding the overall utilization of your Zoom resources.

select
  *
from
  zoom_my_user;

select
  *
from
  zoom_my_user;

Control examples

Schema for zoom_my_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	Zoom account ID that contains this user.
email	text		User's email address.
first_name	text		User's first name.
id	text		User ID.
last_name	text		User's last name.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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_my_user