Table: tfe_team_member - Query Terraform Enterprise Team Members using SQL

Terraform Enterprise is a collaborative, scalable, and enterprise-friendly service for managing infrastructure as code. It provides teams with a centralized platform to collaborate on infrastructure and manage access to resources. Team Members in Terraform Enterprise are the users assigned to a specific team, with permissions and access levels defined by their team's settings.

Table Usage Guide

The tfe_team_member table provides insights into Team Members within Terraform Enterprise. As an Infrastructure Manager, explore member-specific details through this table, including team associations, user IDs, and access permissions. Utilize it to uncover information about team members, such as their roles, the teams they're part of, and their access levels within those teams.

Examples

List all teams and members

Discover the segments that include all teams and their respective members. This can be useful to gain an overview of team composition and structure in your organization.

select
  *
from
  tfe_team_member;

select
  *
from
  tfe_team_member;

List all members of given team

Explore which individuals are part of a specific team, assisting in team management and understanding team composition. This can be particularly useful when auditing team membership or planning resource allocation.

select
  *
from
  tfe_team_member
where
  team_id = 'team-ym4653V1jk9V9FCr';

select
  *
from
  tfe_team_member
where
  team_id = 'team-ym4653V1jk9V9FCr';

List teams for a user

Discover the teams a specific user is a part of, which can be useful for assessing their roles and responsibilities within the organization.

select
  *
from
  tfe_team_member
where
  user_id = 'user-hHKqSi2HyqZ4iJZs';

select
  *
from
  tfe_team_member
where
  user_id = 'user-hHKqSi2HyqZ4iJZs';

List all service accounts

Explore which team members are associated with service accounts. This can be useful for managing access permissions and ensuring security protocols are being followed.

select
  *
from
  tfe_team_member
where
  is_service_account;

select
  *
from
  tfe_team_member
where
  is_service_account = 1;

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_team_member