title | description |
---|---|
Steampipe Table: tfe_team_member - Query Terraform Enterprise Team Members using SQL |
Allows users to query Team Members in Terraform Enterprise, specifically the membership details, providing insights into team structure and access levels. |
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.
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.
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;
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';
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';
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;