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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
creation_time	timestamp with time zone		The creation time of the domain alias.
customer_id	text	=	The customer ID to retrieve all account roles.
domain_alias_name	text	=	The domain alias name.
etag	text		A hash of the metadata, used to ensure there were no concurrent modifications to the resource when attempting an update.
kind	text		The type of the API resource.
parent_domain_name	text	=	The parent domain name that the domain alias is associated with.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
verified	boolean		Indicates 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