steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_group_subgroup

The gitlab_group_subgroup table will obtain information about subgroups for a specific group.

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

Examples

List all subgroups of a group

select
  id,
  name,
  full_path,
  description,
  visibility,
  parent_id,
  created_at
from
  gitlab_group_subgroup
where
  parent_id = 34234;

Schema for gitlab_group_subgroup

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.