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

Query examples

Schema for gitlab_group

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
auto_devops_enabled	boolean		Indicates if the group has auto devops enabled.
avatar_url	text		The url for the groups avatar.
commit_count	bigint		The number of commits in the group.
created_at	timestamp with time zone		Timestamp for when the group was created.
custom_attributes	jsonb		An array of custom attributes.
default_branch_protection	bigint		Indicates level of protection applied to default branch see: https://docs.gitlab.com/ee/api/groups.html#options-for-default_branch_protection for details.
description	text		The groups description.
emails_disabled	boolean		Indicates if this group has email notifications disabled.
extra_shared_runners_minutes_limit	bigint		The limit in minutes of extra time the group can utilise shared runner resources.
file_template_project_id	bigint		The ID of the project template used (if any).
full_name	text		The full name of the group.
full_path	text		The full path of the group
id	bigint	=	The ID of the group.
job_artifacts_size	bigint		The size of job artifacts within the group.
ldap_access	bigint		The LDAP Access associated with group.
ldap_cn	text		The LDAP CN associated with group.
ldap_group_links	jsonb		The LDAP groups linked to the group.
lfs_enabled	boolean		Does the group have Large File System enabled.
lfs_objects_size	bigint		The size of LFS objects within the group.
marked_for_deletion_on	timestamp with time zone		Timestamp for when the group was marked to be deleted.
membership_lock	boolean		Indicates if membership of the group is locked.
mentions_disabled	boolean		Indicates if this group has mention notifications disabled.
name	text		The group name.
packages_size	bigint		The size of packages within the group.
parent_id	bigint		The ID of the groups parent group (for sub-groups)
path	text		The group path.
pipeline_artifacts_size	bigint		The size of pipeline artifacts within the group.
prevent_forking_outside_group	boolean		Indicates if forking is prevented for projects not within the group.
project_creation_level	text		The level at which project creation is permitted developer/maintainer/owner
repository_size	bigint		The size of repositories in the group.
request_access_enabled	boolean		Indicates if the group allows access requests.
require_two_factor_authentication	boolean		Indicates if this group requires 2fa.
runners_token	text		The groups runner token.
share_with_group_lock	boolean		Indicates if this group can be shared with other groups
shared_runners_enabled	boolean		Indicates if shared runners are enabled for the group.
shared_runners_minutes_limit	bigint		The limit in minutes of time the group can utilise shared runner resources.
snippets_size	bigint		The size of snippets within the group.
storage_size	bigint		The storage size of the group on disk.
subgroup_creation_level	text		The level at which sub-group creation is permitted developer/maintainer/owner
two_factor_grace_period	bigint		The grace period (in hours) for 2fa.
uploads_size	bigint		The size of uploads within the group.
visibility	text		The groups visibility (private/internal/public)
web_url	text		The url for the group.
wiki_size	bigint		The size of wikis within the group.