Export to Excel sorted by Host

By default (or when passing the --format xlsx parameter), the tool will export reports in Excel (xlsx) format sorted by vulnerability. If you add the --report-type host parameter, it will generate an Excel report sorted by Host.

This report contains a summary sheet, table of contents, and a sheet per Host containing vulnerability details.

Examples

Create Excel report from 1 OpenVAS XML report, sorted by host, using default settings

openvasreporting -i openvasreport.xml -T host

Create Excel report from multiple OpenVAS XML report, sorted by host, using default settings

openvasreporting -i *.xml -T host
# OR
openvasreporting -i openvasreport.xml -i openvasreport1.xml -i openvasreport2.xml [-i ...] -T HOST

Create Excel report from 1 OpenVAS XML report, sorted by host, reporting only severity level high and up

openvasreporting -i openvasreport.xml -o openvas_report -f xlsx -l h -T  HOST

Result

The final report will look similar to this:

Host Ranking and TOC is sorted according to the maximum CVSS score of a host followed by number of entries at each threat level.

Host worksheets are sorted by CVSS score followed by vulnerability name.

All worksheets are colored according to threat level.