turbot/gitlab_insights

Query: project_without_license_count

Usage

powerpipe query gitlab_insights.query.project_without_license_count

Steampipe Tables

SQL

select
'Without License' as label,
count(*) as value,
case
when count(*) > 0 then 'alert'
else 'ok'
end as type
from
gitlab_my_project
where
license_key is null or license_key = '';

Dashboards

The query is used in the dashboards: