Is there a way to create report in csv format?

[huikang]

Is the --format-csv available in subcommand report? or is there any other way to save the report in csv format? Thanks.

[gy741]

Hello @huikang

I don't think it's applying at the momentarily.

If you need that function, I will add it.

Currently, it supports the following formats.

[-format-json]
[-format-xml]
[-format-one-email]
[-format-one-line-text]
[-format-list]
[-format-full-text]

[huikang]

yes, that would be very helpful as I'd like to input the data in csv format to some data mining pipeline. Thanks.

[jirib]

Would it be possible to little bit describe JSON format? Eg. how to find unfixed vulnerabilities...

[gy741]

@jirib You can use the jq command to filter the desired fields.

For example:

$ cat localhost.json | jq '.scannedCves[] | {cveID, affectedPackages}' | head

{
  "cveID": "CVE-2009-5080",
  "affectedPackages": [
    {
      "name": "groff-base",
      "notFixedYet": true,
      "fixState": "Not fixed yet"
    }
  ]
}

[gy741]

Hello, @huikang

I just added the CSV format.

You can try it.