Steampipe mods are now Powerpipe →

Plugins Docs Home

turbot/gitlab_insights

0Controls

0Variables

branch_1_year_count branch_24_hours_count branch_30_90_days_count branch_30_days_count branch_90_365_days_count branch_count branch_protected_count branch_protection_table branch_table branch_unprotected_count group_2fa_disabled_count group_2fa_enabled_count group_2fa_table group_access_request_count group_access_request_table group_count group_expiring_member_1_year_count group_expiring_member_24_hours_count group_expiring_member_30_90_days_count group_expiring_member_30_days_count group_expiring_member_90_365_days_count group_expiring_member_table group_internal_count group_private_count group_public_count group_visibility_table my_open_issue_1_year_count my_open_issue_24_hours_count my_open_issue_30_90_days_count my_open_issue_30_days_count my_open_issue_90_365_days_count my_open_issue_count my_open_issue_table open_epic_1_year_count open_epic_24_hours_count open_epic_30_90_days_count open_epic_30_days_count open_epic_90_365_days_count open_epic_count open_epic_table open_issue_1_year_count open_issue_24_hours_count open_issue_30_90_days_count open_issue_30_days_count open_issue_90_365_days_count open_issue_count open_issue_table open_merge_request_1_year_count open_merge_request_24_hours_count open_merge_request_30_90_days_count open_merge_request_30_days_count open_merge_request_90_365_days_count open_merge_request_count open_merge_request_table project_101_500_stars_count project_1_100_stars_count project_501_1000_stars_count project_access_request_count project_access_request_table project_count project_expiring_member_1_year_count project_expiring_member_24_hours_count project_expiring_member_30_90_days_count project_expiring_member_30_days_count project_expiring_member_90_365_days_count project_expiring_member_table project_failed_pipeline_count project_failed_pipeline_table project_internal_count project_license_table project_other_license_count project_over_1000_stars_count project_permissive_license_count project_popular_copyleft_license_count project_private_count project_public_count project_star_table project_unstarred_count project_visibility_table project_weak_copyleft_license_count project_without_license_count

Query: my_open_issue_1_year_count

Usage

powerpipe query gitlab_insights.query.my_open_issue_1_year_count

Steampipe Tables

gitlab_my_issue

GitLab plugin

SQL

select
  '> 1 Year' as label,
  count(i.*) as value
from
  gitlab_my_issue i
where
  i.state = 'opened'
  and i.created_at <= now() - '1 year' :: interval;

Dashboards

The query is used in the dashboards:

GitLab My Open Issues Age Report