steampipe plugin install theapsgroup/gitlab

Table: gitlab_group_access_request

The gitlab_group_access_request table can be used to query information about access requests for a specific group.

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

Examples

List all access requests for a specific group

select
id,
username,
name,
state,
access_level,
created_at,
requested_at
from
gitlab_group_access_request
where
group_id = 14597683;

Get a specific access request by id

select
username,
requested_at
from
gitlab_group_access_request
where
group_id = 14597683
and id = 132;

Schema for gitlab_group_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.
group_idbigint=The ID of the group - link to `gitlab_group.id
idbigintThe ID of the access request.
nametextThe name of the user requesting access.
requested_attimestamp with time zoneTimestamp of access request submission.
statetextThe state of the access request.
usernametextThe username of the user requesting access.