steampipe plugin install pipes

Table: pipes_user - Query Pipes User using SQL

Pipes User is a resource within the Pipes platform that allows for user identification and management. It provides a centralized way to manage user details within the Pipes platform, including user ID, name, and email. Pipes User helps users to stay informed about the details and status of various users within the platform.

Table Usage Guide

The pipes_user table provides insights into user details within the Pipes platform. As a system administrator, explore user-specific details through this table, including user ID, name, and email. Utilize it to uncover information about users, such as their identification details and email addresses, facilitating better user management and communication.

Examples

Basic info

Explore the status and identifiers of users in your system. This can be useful for understanding user activity and maintaining account security.

select
id,
display_name,
status,
handle
from
pipes_user;
select
id,
display_name,
status,
handle
from
pipes_user;

Schema for pipes_user

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
avatar_urltextThe avatar URL of the user.
created_attimestamp with time zoneThe creation time of the user.
display_nametextThe display name for the user.
handletextThe handle name of the user.
idtextThe unique identifier for the user.
preview_access_modetextThe preview mode for the current user.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextThe user status.
updated_attimestamp with time zoneThe user's last updated time.
urltextThe URL of the user.
user_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
version_idbigintThe version ID of the user.

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_user