Table: googledirectory_domain - Query Google Directory Domains using SQL

Google Directory Domains is a resource within Google Workspace that allows you to manage your organization's domains. It provides a centralized way to set up and manage domains, including domain verification, alias management, and more. Google Directory Domains helps you stay informed about the status and settings of your domains and take appropriate actions when needed.

Table Usage Guide

The googledirectory_domain table provides insights into domains within Google Workspace Directory. As a system administrator, explore domain-specific details through this table, including domain name, whether the domain is verified, and associated metadata. Utilize it to uncover information about domains, such as their verification status, and to manage domain aliases.

Examples

Basic info

Explore which domains within your Google Directory are primary and when they were created. This can be beneficial for assessing domain configurations and understanding their establishment timeline.

select
  domain_name,
  creation_time,
  is_primary
from
  googledirectory_domain;

select
  domain_name,
  creation_time,
  is_primary
from
  googledirectory_domain;

List unverified domains

Discover the segments that include unverified domains in your Google Directory. This can help you identify potential security risks and take necessary actions to verify these domains.

select
  domain_name,
  creation_time,
  verified
from
  googledirectory_domain
where
  not verified;

select
  domain_name,
  creation_time,
  verified
from
  googledirectory_domain
where
  not verified;

Schema for googledirectory_domain

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
creation_time	timestamp with time zone		Specifies the creation time of the domain.
customer_id	text	=	The customer ID to retrieve all account roles.
domain_aliases	jsonb		A list of domain alias objects.
domain_name	text	=	The domain name of the customer.
etag	text		A hash of the metadata, used to ensure there were no concurrent modifications to the resource when attempting an update.
is_primary	boolean		Indicates if the domain is a primary domain, or not.
kind	text		The type of the API resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
verified	boolean		Indicates the verification state of a domain.

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