DEV Community

Cover image for πŸͺ„ Grype jq tricks : csv for spreadsheets πŸ“Š
adriens for opt-nc

Posted on


πŸͺ„ 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

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


see Group vulnerabilities by severity

🐦 Tweet : image

πŸͺ„ 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 :


🧰 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

Top comments (4)

murtazahashwani profile image
Murtaza Hashwani

Thanks for sharing this tip @adriens

adriens profile image

Thanks for the feedback ;-p

adriens profile image

Great contrib @mbarre πŸ™Œ

adriens profile image

An Animated Guide to Node.js Event Loop

>> Check out this classic DEV post <<