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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.

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