branch_1_year_countbranch_24_hours_countbranch_30_90_days_countbranch_30_days_countbranch_90_365_days_countbranch_countbranch_protected_countbranch_protection_tablebranch_tablebranch_unprotected_countgroup_2fa_disabled_countgroup_2fa_enabled_countgroup_2fa_tablegroup_access_request_countgroup_access_request_tablegroup_countgroup_expiring_member_1_year_countgroup_expiring_member_24_hours_countgroup_expiring_member_30_90_days_countgroup_expiring_member_30_days_countgroup_expiring_member_90_365_days_countgroup_expiring_member_tablegroup_internal_countgroup_private_countgroup_public_countgroup_visibility_tablemy_open_issue_1_year_countmy_open_issue_24_hours_countmy_open_issue_30_90_days_countmy_open_issue_30_days_countmy_open_issue_90_365_days_countmy_open_issue_countmy_open_issue_tableopen_epic_1_year_countopen_epic_24_hours_countopen_epic_30_90_days_countopen_epic_30_days_countopen_epic_90_365_days_countopen_epic_countopen_epic_tableopen_issue_1_year_countopen_issue_24_hours_countopen_issue_30_90_days_countopen_issue_30_days_countopen_issue_90_365_days_countopen_issue_countopen_issue_tableopen_merge_request_1_year_countopen_merge_request_24_hours_countopen_merge_request_30_90_days_countopen_merge_request_30_days_countopen_merge_request_90_365_days_countopen_merge_request_countopen_merge_request_tableproject_101_500_stars_countproject_1_100_stars_countproject_501_1000_stars_countproject_access_request_countproject_access_request_tableproject_countproject_expiring_member_1_year_countproject_expiring_member_24_hours_countproject_expiring_member_30_90_days_countproject_expiring_member_30_days_countproject_expiring_member_90_365_days_countproject_expiring_member_tableproject_failed_pipeline_countproject_failed_pipeline_tableproject_internal_countproject_license_tableproject_other_license_countproject_over_1000_stars_countproject_permissive_license_countproject_popular_copyleft_license_countproject_private_countproject_public_countproject_star_tableproject_unstarred_countproject_visibility_tableproject_weak_copyleft_license_countproject_without_license_count
Query: group_expiring_member_90_365_days_count
Usage
powerpipe query gitlab_insights.query.group_expiring_member_90_365_days_count
Steampipe Tables
SQL
select '90-365 Days' as label, count(m.*) as valuefrom gitlab_group g join gitlab_group_member m on g.id = m.group_idwhere m.state = 'active' and ( m.expires_at is not null and m.expires_at between symmetric now() + '90 days'::interval and now() + '365 days' :: interval );
Dashboards
The query is used in the dashboards: