Table: pipes_tenant_member - Query Pipes Tenant Members using SQL

Pipes Tenant Members are individual users associated with a tenant in the Pipes service. They contain detailed information about each member, including their role, status, and timestamps for creation and updates. Managing these members is crucial for maintaining proper access control and monitoring user activity within the tenant.

Table Usage Guide

The pipes_tenant_member table provides detailed insights into the members of tenants within the Pipes service. As a System Administrator or a DevOps Engineer, use this table to explore member-specific details such as their role, status, and the tenant they belong to. This information is vital for managing access controls, monitoring user activity, and ensuring proper role assignments.

Examples

Basic info

Retrieve basic information about tenant members, including their email, role, and status. This can help in understanding the overall composition of tenant members and monitoring their statuses.

select
  id,
  email,
  role,
  status,
  tenant_id
from
  pipes_tenant_member;

select
  id,
  email,
  role,
  status,
  tenant_id
from
  pipes_tenant_member;

List active members

Identify members who have accepted their invitation to join the tenant, ensuring that only active members are utilizing the services.

select
  id,
  email,
  role,
  status,
  tenant_id
from
  pipes_tenant_member
where
  status = 'accepted';

select
  id,
  email,
  role,
  status,
  tenant_id
from
  pipes_tenant_member
where
  status = 'accepted';

List members by role

Retrieve a list of tenant members filtered by their role. This can help in understanding the distribution of roles within a tenant.

select
  id,
  email,
  role,
  status,
  tenant_id
from
  pipes_tenant_member
where
  role = 'admin';

select
  id,
  email,
  role,
  status,
  tenant_id
from
  pipes_tenant_member
where
  role = 'admin';

Members created in the last 30 days

Find members who were added in the last 30 days to monitor new additions and ensure they are properly integrated into the tenant.

select
  id,
  email,
  role,
  status,
  tenant_id,
  created_at
from
  pipes_tenant_member
where
  created_at >= (current_date - interval '30' day);

select
  id,
  email,
  role,
  status,
  tenant_id,
  created_at
from
  pipes_tenant_member
where
  created_at >= date('now', '-30 day');

Schema for pipes_tenant_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The time of creation in ISO 8601 UTC.
created_by_id	text		The ID of the user that created this.
email	text		The email of the user.
id	text		The unique identifier of the tenant member.
member_id	text		The identifier of the user that belongs to the tenant.
role	text		The role of the tenant user.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the tenant member, i.e., invited or accepted.
tenant_id	text	=	The identifier of the tenant.
updated_at	timestamp with time zone		The time of the last update in ISO 8601 UTC.
updated_by_id	text		The ID of the user that performed the last update.
user_handle	text	=	The handle name of a user.
user_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier for the user.
user_info	jsonb		The user details.
version_id	bigint		The version ID of this item.

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

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

steampipe_export_pipes --config '<your_config>' pipes_tenant_member