steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_project_deployment

The gitlab_project_deployment table can be used to obtain information about deployments associated with a specific project.

However, you must specify a project_id in the where or join clause.

Examples

List all deployments for a specific project

select
  id,
  iid,
  ref,
  sha,
  status,
  created_at,
  updated_at,
  user_id,
  user_username,
  environment_id,
  environment_name,
  deployable_id,
  deployable_status,
  deployable_stage,
  deployable_name,
  deployable_ref,
  deployable_commit_id,
  deployable_pipeline_id
from
  gitlab_project_deployment
where
  project_id = 14597683;

Get a specific deployment for a project

select
  id,
  iid,
  ref,
  sha,
  status,
  created_at,
  updated_at,
  user_id,
  user_username,
  environment_id,
  environment_name,
  deployable_id,
  deployable_status,
  deployable_stage,
  deployable_name,
  deployable_ref,
  deployable_commit_id,
  deployable_pipeline_id
from
  gitlab_project_deployment
where
  project_id = 14597683
  and id = 1486132;

Get information about the commit associated with a specific deployment

select
  d.id,
  d.environment_name,
  c.author_email,
  c.short_id,
  c.title,
  c.message
from
  gitlab_project_deployment d
  left outer join gitlab_commit c on d.project_id = c.project_id
  and d.deployable_commit_id = c.id
where
  d.project_id = 14597683;

Schema for gitlab_project_deployment

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone		Timestamp of when the deployment was created.
deployable_commit_id	text		The ID of the commit for the deployable.
deployable_id	bigint		The ID of the deployable.
deployable_name	text		The name of the deployable.
deployable_pipeline_id	bigint		The ID of the pipeline for the deployable.
deployable_ref	text		The ref of the deployable.
deployable_stage	text		The stage of the deployable.
deployable_status	text		The status of the deployable.
environment_id	bigint		The ID of the environment the deployment is deployed to.
environment_name	text		The name of the environment the deployment is deployed to.
id	bigint	=	The ID of the deployment.
iid	bigint		The internal ID of the deployment.
project_id	bigint	=	The ID of the project - link to `gitlab_project.id
ref	text		The reference associated with the deployment (branch name or tag).
sha	text		The commit SHA at which the deployment was run against.
status	text		The status of the deployment (running/success/failed/canceled).
updated_at	timestamp with time zone		Timestamp of when the deployment was last updated.
user_id	bigint		The ID of the user whom triggered the deployment.
user_username	text		The username of the user whom triggered the deployment.