steampipe plugin install pipes

Table: pipes_process - Query Pipes Processes using SQL

Pipes provides a way to query and manage processes for various Steampipe plugins, including retrieving process status, duration, and other details. It helps you stay informed about the state and performance of your Steampipe plugins and take appropriate actions based on the retrieved data.

Table Usage Guide

The pipes_process table provides insights into running processes within Pipes. As a DevOps engineer, this table allows you to explore process-specific details, including status, duration, and associated metadata. Utilize it to monitor and manage processes, such as those with long durations, the state of different processes, and the verification of process details.

Examples

Basic info

Explore which processes are currently active and when they were created. This can help in understanding the operational flow and managing resources effectively.

select
id,
identity_handle,
identity_type,
pipeline_id,
type,
state,
created_at
from
pipes_process;
select
id,
identity_handle,
identity_type,
pipeline_id,
type,
state,
created_at
from
pipes_process;

List processes that are being run by an identity pipeline

Explore which processes are being managed by a specific pipeline. This can be useful to understand the pipeline's activity and monitor its performance.

select
id,
identity_handle,
identity_type,
pipeline_id,
type,
state,
created_at
from
pipes_process
where
pipeline_id is not null;
select
id,
identity_handle,
identity_type,
pipeline_id,
type,
state,
created_at
from
pipes_process
where
pipeline_id is not null;

List user processes

Explore which processes are initiated by users within a system. This can be particularly useful to monitor user activity and manage system resources effectively.

select
id,
identity_handle,
identity_type,
pipeline_id,
type,
state,
created_at
from
pipes_process
where
identity_type = 'user';
select
id,
identity_handle,
identity_type,
pipeline_id,
type,
state,
created_at
from
pipes_process
where
identity_type = 'user';

List running processes

Explore which processes are currently active. This is useful for monitoring ongoing operations and identifying any that may be causing issues or consuming excessive resources.

select
id,
identity_handle,
identity_type,
pipeline_id,
type,
state,
created_at
from
pipes_process
where
state = 'running';
select
id,
identity_handle,
identity_type,
pipeline_id,
type,
state,
created_at
from
pipes_process
where
state = 'running';

Schema for pipes_process

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
created_attimestamp with time zoneThe time when the process was created.
created_byjsonbInformation about the user who created the process.
created_by_idtextThe unique identifier of the user who created the process.
idtext=The unique identifier for the process.
identity_handletext=The handle of the identity.
identity_idtext=The unique identifier of the identity to which the process belongs to.
identity_typetextThe type of identity, can be org/user.
pipeline_idtextThe unique identifier for the pipeline if a process is for a pipeline run/execution.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetextThe current state of the process.
typetextThe type of action executed by the process.
updated_attimestamp with time zoneThe time when the process was last updated.
updated_byjsonbInformation about the user who last updated the process.
updated_by_idtextThe unique identifier of the user who last updated the process.
user_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
version_idbigintThe current version ID for the process.

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_process