turbot/zoom

GitHub
steampipe plugin install zoomsteampipe plugin install zoom

Table: zoom_recording

Query information about cloud recordings of meetings in the Zoom account.

Notes:

  • A user_id must be provided in all queries to this table.
  • 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

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

List all cloud recordings for a given host by email

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

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'

Get a cloud recording by ID

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

.inspect zoom_cloud_recording

Meetings and webinars recorded to the cloud.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextUnique Identifier of the user account.
durationbigintRecording duration.
idbigintMeeting ID - also known as the meeting number.
recording_countbigintNumber of recording files returned in the response of this API call.
recording_filesjsonbList of recording file.
settingsjsonbSettings for the recording.
share_urltextShare URL for the recording.
start_timetimestamp with time zoneRecording start time in GMT/UTC. Start time will not be returned if the recording is an instant recording.
topictextRecording topic.
total_sizebigintTotal size of the recording.
typebigintRecording Types: 1 - Instant recording. 2 - Scheduled recording. 3 - Recurring recording with no fixed time. 8 - Recurring recording with fixed time.
user_idtextID of the user who is set as the host of the recording.
uuidtextUnique Meeting Identifier. Each instance of the meeting will have its own UUID.