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;

Schema for tfe_team_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
avatar_url	text		URL of the user avatar.
is_service_account	boolean		True if the user is a service account.
organization_name	text	=, !=, ~~, ~~, !~~, !~~	ID of the organization containing the team.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
team_id	text		ID of the team.
two_factor	jsonb		Details of two factor authentication for the user.
user_id	text		ID of the user.
username	text		Username of the team member.
v2_only	boolean		If true, the user can only use v2.

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_team_member