Table: zoom_cloud_recording - Query Zoom Cloud Recordings using SQL

Zoom Cloud Recording is a feature within Zoom Meetings that allows you to record your meetings and webinars, and securely store them in the cloud. It provides the ability to access, share, and download the recorded meetings and webinars. Zoom Cloud Recording helps you keep track of your meetings and webinars, ensuring that important information is not lost.

Table Usage Guide

The zoom_cloud_recording table provides insights into Zoom Cloud Recordings within Zoom Meetings. As a meeting organizer or participant, explore recording-specific details through this table, including meeting IDs, recording start and end times, file types, and download URLs. Utilize it to manage and keep track of your recorded meetings and webinars, ensuring that important information is easily accessible and securely stored.

Important Notes

You must specify the user_id in the where clause to query this table.
You can use start_time to specify the range of meetings to return (max 30 days).
Default time range is the last 30 days.

Examples

List all cloud recordings for a given host

Explore all cloud recordings associated with a specific host to better manage storage or review past meetings. This can be particularly useful for tracking meeting history, auditing content, or retrieving specific recordings for reference.

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

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

List all cloud recordings for a given host by email

Explore all cloud recordings associated with a specific host's email. This is useful for auditing purposes or for gathering insights into a particular user's activity on the platform.

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

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

List all cloud recordings for Sep 2019

Explore all cloud recordings from September 2019, specifically for a user with a particular email address. This is useful for auditing purposes or to find a specific recording from that period.

select
  *
from
  zoom_cloud_recording
where
  user_id in (
    select
      id
    from
      zoom_user
    where
      email = 'dwight@dundermifflin.com'
  )
  and start_time >= '2019-09-01'
  and start_time <= '2021-09-30';

select
  *
from
  zoom_cloud_recording
where
  user_id in (
    select
      id
    from
      zoom_user
    where
      email = 'dwight@dundermifflin.com'
  )
  and start_time >= date('2019-09-01')
  and start_time <= date('2021-09-30');

Get a cloud recording by ID

Discover the details of a specific Zoom cloud recording by using its unique identifier. This can be beneficial for auditing purposes, or to gain insights into a particular meeting or webinar. To get a recording by ID it must be within the time range of the list. The underlying API does not support getting a historical recording by ID.

select
  *
from
  zoom_cloud_recording
where
  id = 912357281124;

select
  *
from
  zoom_cloud_recording
where
  id = 912357281124;

Schema for zoom_cloud_recording

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	Unique Identifier of the user account.
duration	bigint		Recording duration.
id	bigint		Meeting ID - also known as the meeting number.
recording_count	bigint		Number of recording files returned in the response of this API call.
recording_files	jsonb		List of recording file.
settings	jsonb		Settings for the recording.
share_url	text		Share URL for the recording.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
start_time	timestamp with time zone	>, >=, =, <, <=	Recording start time in GMT/UTC. Start time will not be returned if the recording is an instant recording.
topic	text		Recording topic.
total_size	bigint		Total size of the recording.
type	bigint		Recording Types: 1 - Instant recording. 2 - Scheduled recording. 3 - Recurring recording with no fixed time. 8 - Recurring recording with fixed time.
user_id	text	=	ID of the user who is set as the host of the recording.
uuid	text		Unique Meeting Identifier. Each instance of the meeting will have its own 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_cloud_recording