Table: tfe_organization - Query Terraform Enterprise Organizations using SQL

A Terraform Enterprise Organization represents a collection of users, teams, and workspaces. Within an organization, users can collaborate and manage workspaces together. The organization also provides a context in which resources such as Sentinel policies and SSH keys can be shared.

Table Usage Guide

The tfe_organization table provides insights into organizations within Terraform Enterprise. As a DevOps engineer, explore organization-specific details through this table, including membership, collaboration status, and associated workspaces. Utilize it to uncover information about organizations, such as those with specific team access, the collaboration status between teams, and the management of workspaces.

Examples

List organizations

Explore the different organizations within your network. This allows for better management and understanding of the various groups interacting with your systems.

select
  *
from
  tfe_organization;

select
  *
from
  tfe_organization;

Organizations that do not require two factor

Discover the organizations that do not comply with two-factor authentication. This can be useful for assessing security measures and identifying potential vulnerabilities within your organization.

select
  name,
  two_factor_conformant
from
  tfe_organization
where
  not two_factor_conformant;

select
  name,
  two_factor_conformant
from
  tfe_organization
where
  not two_factor_conformant;

Schema for tfe_organization

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
collaborator_auth_policy	text		Authentication policy: password, two_factor_mandatory.
cost_estimation_enabled	boolean		Whether or not the cost estimation feature is enabled for all workspaces in the organization.
created_at	timestamp with time zone		Time when the token was created.
email	text		Email address for notifications.
external_id	text		External ID for the organization.
name	text	=	Name of the organization.
owners_team_saml_role_id	text		SAML role mapped to the owners team.
permissions	jsonb		Permissions for the organization.
saml_enabled	boolean		True if SAML is enabled for the organization.
session_remember	bigint		Session expiration (minutes).
session_timeout	bigint		Session timeout after inactivity (minutes).
trial_expires_at	timestamp with time zone		When the trial, if any, expires.
two_factor_conformant	boolean		If true, members are required to use two factor authentication.

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

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

steampipe_export_tfe --config '<your_config>' tfe_organization