Skip to content

Use SeBAz to create report from modified CSV(s)

Deepak Balaji edited this page Apr 4, 2020 · 2 revisions

This page explains how to modify the spreadsheet and generate a report from this file after the fact

Modifying the spreadsheet

There will be the following results in the spreadsheet

  • PASS

These indicates tests that satisfy the criteria as laid out in the CIS Benchmark

  • FAIL

These indicates tests that don't satisfy the criteria as laid out in the CIS Benchmark

  • CHEK

These indicates results from tests that could not be checked against the criteria as laid out in the CIS Benchmark. These need to be manually reviewed by the auditor with the result in the explanation column of the spreadsheet and be changed to PASS or FAIL

After changing all CHEK to PASS or FAIL, use countif and/or vlookup to see how many have passed and what is the modified score of the system.

Make the necessary changes in the last two columns of the CSV document. Now you are ready to generate the modified report.

Generate report

As explained here, use the following command to generate the modified report.

./SeBAz -r "*"

./SeBAz --report "*"

Unless you change the score in the spreadsheet, the score WILL NOT change in the generated report

Clone this wiki locally