turbot/gitlab_insights

Query: project_other_license_count

Usage

powerpipe query gitlab_insights.query.project_other_license_count

Steampipe Tables

SQL

select
'Other' as label,
count(*) as value
from
gitlab_my_project
where
license_key is not null
and license_key not in ('lgpl-3.0','lgpl-2.1','mpl-2.0','epl-2.0','osl-3.0','eupl-1.2','gpl-3.0','gpl-2.0','agpl-3.0','agpl-2.0','cc-by-sa-4.0','apsl','apache-2.0','mit','bsd-3','bsd-2','bsd-3-clause','bsd2-clause', 'cc-by-4.0', 'wtfpl', 'ms-pl', 'unlicensed');

Dashboards

The query is used in the dashboards: