TheLazy.Dev
Portfolio GitHub

Blog

docker |security |devops |infosec

🪄 Grype jq tricks : csv for spreadsheets 📊

adriens

adriens

Posted on October 18, 2022

🪄 Grype jq tricks : csv for spreadsheets 📊

❔ About

Often, when you talk about an image vulnerabilities, you need to get that kind of charts in a spreadsheet:

Image description

Therefore we created the following issue :

🪄 Implement jq trick to group and count by severity #8

adriens avatar
adriens posted on

Provide the jq query that takes in input a grype -o json command and returns

"Negligible",0
"Low",4
"High",10

see Group vulnerabilities by severity

🐦 Tweet : image

View on GitHub

🪄 The jq trick

Just follow (and bookmark) the following guidelines to enjoy the trick :

Image description

🍿 Showtime

Enough talk, let's see the trick in action :

🔖 Resources

GitHub logo opt-nc / grype-contribs

A set of resources around Anchore's grype tool

❔ About

The aim of this repo is to summarize some resources around Grype to take the best ouf this great tool.

🔖 Discover grype-contribs

To learn more about this project, take a glance at :

asciicast

🧰 Prerequisites

For an optimal usage of these resources, you'll need :

  • git
  • brew installed
  • python3 and pip

Install tools

brew tap anchore/grype
brew install grype

We'll use termgraph, "A command-line tool that draws basic graphs in the terminal," :

python3 -m pip install termgraph

Finally clone this repo :

gh repo clone opt-nc/grype-contribs
cd grype-contribs

👉 You are ready.

📜 Templating

Since v0.42.0, and its issue #724 it is possible to transform analysis report with templates.

This feature makes it possible to build nicely useable and highly customizable reports.

📊 Aggregated report in the terminal (termgraph)

…
Enter fullscreen mode Exit fullscreen mode
View on GitHub
💖 💪 🙅 🚩
adriens
adriens

Posted on October 18, 2022

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

🪄 Grype jq tricks : csv for spreadsheets 📊
docker 🪄 Grype jq tricks : csv for spreadsheets 📊

October 18, 2022