turbot/googledirectory
steampipe plugin install googledirectory

Table: googledirectory_domain_alias - Query Google Workspace Domain Aliases using SQL

A Google Workspace Domain Alias is an alternative name for a Google Workspace domain, which allows users to log in to their accounts and services using different domain names. Domain aliases are particularly useful for organizations that operate under multiple brand names or have different domains for different departments. They are managed through the Google Admin console and can be used with all Google Workspace services.

Table Usage Guide

The googledirectory_domain_alias table provides insights into domain aliases within Google Workspace. As a Google Workspace administrator, explore alias-specific details through this table, including the parent domain name, creation time, and whether the alias is verified. Utilize it to manage and monitor your organization's domain aliases, ensuring that all aliases are correctly set up and verified.

Examples

Basic info

Explore which domain aliases in your Google Directory have been verified and when they were created. This can be used to maintain a secure and organized domain structure.

select
domain_alias_name,
creation_time,
verified
from
googledirectory_domain_alias;
select
domain_alias_name,
creation_time,
verified
from
googledirectory_domain_alias;

List unverified domain aliases

Discover the segments that consist of unverified domain aliases, enabling you to identify potential areas of risk and take appropriate action to verify them.

select
domain_alias_name,
creation_time,
verified
from
googledirectory_domain_alias
where
not verified;
select
domain_alias_name,
creation_time,
verified
from
googledirectory_domain_alias
where
not verified;

List domain aliases by parent domain

Explore the different domain aliases associated with a specific parent domain. This can be useful for understanding the structure and organization of your domain aliases, as well as for verifying their creation times and statuses.

select
domain_alias_name,
parent_domain_name,
creation_time,
verified
from
googledirectory_domain_alias
where
parent_domain_name = 'domain.com';
select
domain_alias_name,
parent_domain_name,
creation_time,
verified
from
googledirectory_domain_alias
where
parent_domain_name = 'domain.com';

Schema for googledirectory_domain_alias

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
creation_timetimestamp with time zoneThe creation time of the domain alias.
customer_idtext=The customer ID to retrieve all account roles.
domain_alias_nametext=The domain alias name.
etagtextA hash of the metadata, used to ensure there were no concurrent modifications to the resource when attempting an update.
kindtextThe type of the API resource.
parent_domain_nametext=The parent domain name that the domain alias is associated with.
verifiedbooleanIndicates the verification state of a domain alias.

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

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

steampipe_export_googledirectory --config '<your_config>' googledirectory_domain_alias