steampipe plugin install theapsgroup/gitlab

Table: gitlab_project_access_request

The gitlab_project_access_request table can be used to query information about access requests for a specific project.

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

Examples

List all access requests for a specific project

select
id,
username,
name,
state,
access_level,
created_at,
requested_at
from
gitlab_project_access_request
where
project_id = 45453535;

Get a specific access request by id

select
username,
requested_at
from
gitlab_project_access_request
where
project_id = 45453535
and id = 873;

Schema for gitlab_project_access_request

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
access_levelbigintThe numeric value of the access level requested by the user.
access_level_descriptiontextThe access level requested by the user.
created_attimestamp with time zoneTimestamp of access request creation.
idbigintThe ID of the access request.
nametextThe name of the user requesting access.
project_idbigint=The ID of the project - link to `gitlab_project.id
requested_attimestamp with time zoneTimestamp of access request submission.
statetextThe state of the access request.
usernametextThe username of the user requesting access.