turbot/googleworkspace
steampipe plugin install googleworkspace

Table: googleworkspace_calendar - Query Google Workspace Calendars using SQL

Google Workspace Calendar is a time-management and scheduling service developed by Google. It enables users to create and edit events, manage multiple calendars, and share calendars with others. Google Workspace Calendar is fully integrated with other Google services, providing seamless scheduling and collaboration capabilities.

Table Usage Guide

The googleworkspace_calendar table provides insights into calendars within Google Workspace. As a system administrator or IT professional, explore calendar-specific details through this table, including the summary, description, location, and timezone. Utilize it to manage and monitor the usage of calendars, such as those shared with many users, the timezone settings of each calendar, and the description and summary details.

Important Notes

  • You must specify the id in the where or join clause (where id=, join googleworkspace_calendar c on c.id=) to query this table.

Examples

Basic info

Explore the basic details of a specific user's Google Workspace Calendar. This can help in understanding the user's time zone and other relevant information to enhance scheduling and coordination.

select
summary,
id,
timezone
from
googleworkspace_calendar
where
id = 'user@domain.com';
select
summary,
id,
timezone
from
googleworkspace_calendar
where
id = 'user@domain.com';

Schema for googleworkspace_calendar

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
conference_propertiesjsonbDescribes the conferencing properties for this calendar.
descriptiontextDescription of the calendar.
etagtextETag of the resource.
idtext=Identifier of the calendar.
locationtextGeographic location of the calendar as free-form text.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
summarytextTitle of the calendar.
timezonetextThe time zone of the calendar.

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)" -- googleworkspace

You can pass the configuration to the command with the --config argument:

steampipe_export_googleworkspace --config '<your_config>' googleworkspace_calendar