Example dashboard charts and layout for Development and Secure SDLC:
The above example contains the following charts/queries:
Repos with the most vulnerability findings
Chart type: bar
Query:
Find CodeRepo as code that has (Vulnerability|Finding) as vuln return code.name as x, count(vuln) as y order by y desc limit 10
PRs with Self-approved commits that merged in past 2 days
(Left Chart)
Chart type: number
Query:
Find PR with approved=false and merged=true and updatedOn > date.now-2days as pr Return count(pr) as value
(Right Chart)
Chart type: table
Query:
Find PR with approved=false and merged=true and updatedOn > date.now-2days as pr Return pr.displayName, pr.name, pr.webLink
PRs with commits by unknown author that merged in past 2 days
(Left Chart)
Chart type: number
Query:
Find PR with validated=false and merged=true and updatedOn > date.now-2days as pr Return count(pr) as value
(Right Chart)
Chart type: table
Query:
Find PR with validated=false and merged=true and updatedOn > date.now-2days as pr Return pr.displayName, pr.name, pr.webLink
Number of Code Repos by Project
Chart type: pie
Query:
Find CodeRepo AS repo that relates to (Project|github_account) as p Return p.name as name, count(repo) AS value
Top Open PR count by developer
Chart type: bar
Query:
Find Person that is User AS u that opened PR that open=true AS pr Return u.displayName AS x, count(pr) AS y Order By y Desc Limit 10
Github vs. Bitbucket Repos
Chart type: bar
Query:
Find CodeRepo as repo Return repo._type as name, count(repo) as value
On this page:
Development and Secure SDLC Dashboard Repos with the most vulnerability findings PRs with Self-approved commits that merged in past 2 days PRs with commits by unknown author that merged in past 2 days Number of Code Repos by Project Top Open PR count by developer Github vs. Bitbucket Repos
Comments
0 comments
Please sign in to leave a comment.