theapsgroup/gitlab

steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_group

A group is a collection of projects & members.

The gitlab_group table can be used to query groups (where you are a member of for authenticated user, unless authenticated user is an admin in which case, all groups will be available).

Examples

Get all Groups

select
*
from
gitlab_group;

Get top level groups

select
*
from
gitlab_group
where
parent_id is null;

Get private groups

select
*
from
gitlab_group
where
visibility = 'private';

Obtain a count of different visibility levels

select
visibility,
count(id) as group_count
from
gitlab_group
group by
visibility

.inspect gitlab_group

Groups within GitLab

NameTypeDescription
auto_devops_enabledbooleanIndicates if the group has auto devops enabled.
avatar_urltextThe url for the groups avatar.
created_attimestamp without time zoneTimestamp for when the group was created.
custom_attributesjsonbAn array of custom attributes.
descriptiontextThe groups description.
emails_disabledbooleanIndicates if this group has email notifications disabled.
extra_shared_runners_minutes_limitbigintThe limit in minutes of extra time the group can utilise shared runner resources.
full_nametextThe full name of the group.
full_pathtextThe full path of the group
idbigintThe ID of the group.
ldap_accessbigintThe LDAP Access associated with group.
ldap_cntextThe LDAP CN associated with group.
ldap_group_linksjsonbThe LDAP groups linked to the group.
lfs_enabledbooleanDoes the group have Large File System enabled.
marked_for_deletion_ontimestamp without time zoneTimestamp for when the group was marked to be deleted.
membership_lockbooleanIndicates if membership of the group is locked.
mentions_disabledbooleanIndicates if this group has mention notifications disabled.
nametextThe group name.
parent_idbigintThe ID of the groups parent group (for sub-groups)
pathtextThe group path.
project_creation_leveltextThe level at which project creation is permitted developer/maintainer/owner
request_access_enabledbooleanIndicates if the group allows access requests.
require_two_factor_authenticationbooleanIndicates if this group requires 2fa.
runners_tokentextThe groups runner token.
share_with_group_lockbooleanIndicates if this group can be shared with other groups
shared_runners_minutes_limitbigintThe limit in minutes of time the group can utilise shared runner resources.
subgroup_creation_leveltextThe level at which sub-group creation is permitted developer/maintainer/owner
two_factor_grace_periodbigintThe grace period (in hours) for 2fa.
visibilitytextThe groups visibility (private/internal/public)
web_urltextThe url for the group.