GitHub Default Branch Protection ReportGitHub Open Issue Age ReportGitHub Open Pull Request Age ReportGitHub Organization 2FA ReportGitHub Organization Member Privileges ReportGitHub Organization Plan Seat ReportGitHub Organization Security Advisory ReportGitHub Repository License ReportGitHub Repository Security Advisory ReportGitHub Repository Stargazers ReportGitHub Repository Visibility Report
Dashboard: GitHub Repository Security Advisory Report
This report answers the following questions:
- Across all my repositories do I have any open security vulnerability alerts?
This dashboard contains 5 cards and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-github-insightsStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select GitHub Repository Security Advisory Report dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run github_insights.dashboard.repository_security_advisory_report --shareQueries
This dashboard uses the the following queries:
select 'Open Advisories' as label, count(*) as valuefrom github_my_repository r join github_repository_dependabot_alert a on r.name_with_owner = a.repository_full_namewhere a.state = 'open' and r.name_with_owner like 'turbot/steampipe-plugin%' and r.name_with_owner not in ('turbot/steampipe-plugin-papertrail', 'turbot/steampipe-plugin-wordpress', 'turbot/steampipe-plugin-html', 'turbot/steampipe-plugin-chaos', 'turbot/steampipe-plugin-chaosratelimit', 'turbot/steampipe-plugin-chaosdynamic', 'turbot/steampipe-plugin-pokemon', 'turbot/steampipe-plugin-gitlab');