Table: zoom_meeting - Query Zoom Meetings using SQL

Zoom Meetings is a service offered by Zoom that allows users to host or join virtual meetings with high-quality video, audio, and screen sharing options. It supports a variety of meeting types, including one-on-one meetings, group video conferences, and webinars. Zoom Meetings allows for easy scheduling, recording, and sharing of meetings.

Table Usage Guide

The zoom_meeting table provides insights into Zoom Meetings within the Zoom platform. As a system administrator or a team manager, explore meeting-specific details through this table, including meeting ID, topic, type, start time, duration, timezone, and status. Utilize it to monitor and manage the meetings occurring within your organization, ensuring efficient communication and collaboration.

Important Notes

You must specify the user_id in the where clause to query this table.

Examples

List all meetings for a given host

Explore all meetings organized by a specific host. This is useful for auditing purposes, allowing you to understand the host's meeting patterns and frequency.

select
  *
from
  zoom_meeting
where
  user_id = 'RCKlotFLRpe-Hbnv-VK3CA';

select
  *
from
  zoom_meeting
where
  user_id = 'RCKlotFLRpe-Hbnv-VK3CA';

List all meetings for a given host by email

Determine the meetings conducted by a specific host using their email address. This is useful for tracking a host's meeting history and understanding their engagement levels.

select
  *
from
  zoom_meeting
where
  user_id in (
    select
      id
    from
      zoom_user
    where
      email = 'dwight@dundermifflin.com'
  );

select
  *
from
  zoom_meeting
where
  user_id in (
    select
      id
    from
      zoom_user
    where
      email = 'dwight@dundermifflin.com'
  );

Get a meeting by ID

Discover the details of a specific meeting using its unique identifier, which can be useful for auditing purposes or for gathering information about a past meeting.

select
  *
from
  zoom_meeting
where
  id = 912357281124;

select
  *
from
  zoom_meeting
where
  id = 912357281124;

Schema for zoom_meeting

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_id	text		Zoom account ID.
agenda	text		Meeting description.
created_at	timestamp with time zone		Time when the meeting was created.
duration	bigint		Meeting duration.
encrypted_password	text		Encrypted passcode for third party endpoints (H323/SIP).
h323_password	text		H.323/SIP room system passcode.
id	bigint	=	Meeting ID, also known as the meeting number.
join_url	text		URL using which participants can join a meeting.
occurrences	jsonb		Array of occurrence objects.
password	text		Meeting passcode.
pmi	text		Personal meeting ID.
recurrence	jsonb		Recurrence details.
settings	jsonb		Meeting settings.
start_time	timestamp with time zone		Meeting start time in GMT/UTC. Start time will not be returned if the meeting is an instant meeting.
start_url	text		The start_url of a meeting is a URL using which a host or an alternative host can start the Meeting.
status	text		Meeting status: waiting or started.
timezone	text		Timezone to format the meeting start time.
topic	text		Meeting topic.
tracking_fields	jsonb		Tracking fields.
type	bigint		Meeting Types: 1 - Instant meeting. 2 - Scheduled meeting. 3 - Recurring meeting with no fixed time. 8 - Recurring meeting with fixed time.
user_id	text	=	ID of the user who is set as the host of the meeting.
uuid	text		Unique Meeting ID. Each meeting instance will generate its own Meeting UUID.

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_meeting