Table: googledirectory_org_unit - Query Google Directory Org Units using SQL

Google Directory is a service within Google Workspace that manages and organizes information about users, groups, and devices. It provides a centralized way to manage organizational units, users, groups, and devices in a Google Workspace account. Google Directory helps you stay informed about the structure and organization of your Google Workspace resources.

Table Usage Guide

The googledirectory_org_unit table provides insights into organizational units within Google Directory. As a system administrator, explore unit-specific details through this table, including names, descriptions, parent organizational units, and associated metadata. Utilize it to uncover information about the hierarchy and structure of your organization within Google Workspace.

Examples

Basic info

Explore the organization structure within Google Directory to understand its hierarchy and descriptions. This can be beneficial for managing resources and permissions within your organization.

select
  name,
  org_unit_id,
  org_unit_path,
  description
from
  googledirectory_org_unit;

select
  name,
  org_unit_id,
  org_unit_path,
  description
from
  googledirectory_org_unit;

Get org unit by ID

Explore the specific organizational unit within Google Directory by using its unique ID. This assists in obtaining detailed information about the unit, such as its name, path, and description, which can be useful for managing and understanding the structure of your organization.

select
  name,
  org_unit_id,
  org_unit_path,
  description
from
  googledirectory_org_unit
where
  org_unit_id = 'id:03pk8a4z4t34g1w';

select
  name,
  org_unit_id,
  org_unit_path,
  description
from
  googledirectory_org_unit
where
  org_unit_id = 'id:03pk8a4z4t34g1w';

Get org unit by path

Explore the specific organizational unit within your Google Directory by its unique path. This allows you to obtain crucial details about the unit, such as its name and description, which can be beneficial for managing your organizational structure.

select
  name,
  org_unit_id,
  org_unit_path,
  description
from
  googledirectory_org_unit
where
  org_unit_path = '/DM';

select
  name,
  org_unit_id,
  org_unit_path,
  description
from
  googledirectory_org_unit
where
  org_unit_path = '/DM';

Schema for googledirectory_org_unit

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
block_inheritance	boolean		Determines if a sub-organizational unit can inherit the settings of the parent organization.
customer_id	text	=	The customer ID to retrieve all account roles.
description	text		A short description of the organizational unit.
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.
name	text		The organizational unit's path name.
org_unit_id	text	=	The unique ID of the organizational unit.
org_unit_path	text	=	The full path to the organizational unit.
parent_org_unit_id	text		The unique ID of the parent organizational unit.
parent_org_unit_path	text		The organizational unit's parent path.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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_org_unit