steampipe plugin install zoom

Table: zoom_role - Query Zoom Roles using SQL

Zoom Roles is a feature within Zoom that allows administrators to assign permissions to users based on their role. It provides a way to manage access control and permissions for different users within the organization. Zoom Roles help to ensure that users have the appropriate access rights for their job function and responsibilities.

Table Usage Guide

The zoom_role table provides insights into roles within Zoom. As an administrator, explore role-specific details through this table, including role id, name, total members, and privileges. Utilize it to uncover information about roles, such as those with specific permissions, the number of users assigned to each role, and the specific privileges associated with each role.

Examples

List all roles

Explore the various roles within your Zoom account, allowing you to manage and organize your team more effectively. This query helps in maintaining a clear hierarchy and understanding the permissions associated with each role.

select
*
from
zoom_role
order by
name;
select
*
from
zoom_role
order by
name;

Get a role by ID

Discover the segments that are associated with a specific role ID in Zoom to better manage permissions and responsibilities within your team. This can be particularly useful for administrators who need to understand the scope of a role for delegation or auditing purposes.

select
*
from
zoom_role
where
id = '1';
-- Owner role
select
*
from
zoom_role
where
id = '1';
-- Owner role

Get privileges for each role

Explore which privileges are assigned to each role within the Zoom platform to understand user permissions and rights. This can help in managing user access and ensuring appropriate security measures are in place.

select
r.id,
r.name,
p
from
zoom_role as r,
jsonb_array_elements(r.privileges) as p
order by
r.name,
p;
select
r.id,
r.name,
p.value as p
from
zoom_role as r,
json_each(r.privileges) as p
order by
r.name,
p.value;

Find all roles with permission to edit account settings

Identify roles that have the authority to modify account settings, with the intent of understanding which roles have this level of access and how many members each role contains.

select
id,
name,
total_members
from
zoom_role
where
privileges ? 'AccountSetting:Edit'
order by
total_members;
select
id,
name,
total_members
from
zoom_role
where
json_extract(privileges, '$."AccountSetting:Edit"') is not null
order by
total_members;

Schema for zoom_role

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextZoom account ID.
descriptiontextRole description.
idtext=Role ID.
nametextRole name.
privilegesjsonbPrivileges assigned to the role.
sub_account_privilegesjsonbPrivileges for management of sub-accounts.
total_membersbigintTotal number of members in the role.

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_role