Export HP Fortify SCA 4.10 results in EXCEL format

Question

I scanned with HP Fortify SCA 4.10 . Now I would like to export the raw results into Excel format to do data massaging to generate pivot tables. Can anybody suggest a easy or hard way to do it.

Answer 1

Reference this url for the DB script to get the EXCEL format (export DB output to Excel): How to diff Fortify SCA scans

Generate a pdf/rtf/xml Report from an existing FPR

1. ~AWB_Installation_Dir/bin/ReportGenerator -format pdf -f outputFile.pdf -source existing.fpr (replace pdf to your target format, excluding excel format)

Generate a XML Report in AWB

1. Open Audit Workbench and load your FPR file.

2. Generate a Report (click the "Reports" button, "Generate Report" window popped up).

   a. Select Report = "Fortify Developer Workbook" (drop down menu)

   b. In "Refine Issues in Subsection" field, paste category:!"" (or click Advanced..", and select Category, is not, )

   c. Click "Save Report"

   d. Set the Format to "XML Report" and set the destination location.

   e. Click "Save" to generate the report.

Configure Excel 2013

First you need to make sure the developer tab is enabled.

a. In Excel, click on File->Options->Customize Ribbon

b. Make sure "Developer" is checked on the right side under "Customize the Ribbon: Main Tabs"

c. Click OK.

Import the XML Schema

Now click on the Developer tab.

a. In the XML section, click on the Source button. An "XML Source" panel will appear on the right side.

b. Click on the "XML Maps" button.

c. Click on the Add button.

d. Navigate to "<HP Fortify SCA install dir>\Core\config\schemas" and select "ReportDefinition.xsd".

e. In the list that appears, select "ReportDefinition", then click OK.

f. Click OK.

Configure the Worksheet Columns

In the "XML Source" panel select the columns that you would like in the table. For example:

a) under Issue, select Category and drag-n-drop it to cell A1.

b) select Friority and drag-n-drop it to B1

c) select FileName under Source and drag-n-drop it to C1

d) under Tag, select Name and drag-n-drop it to D1

e) select Value and drag it to E1

You can select whatever columns you like.

Select the Data Source and Generate the Table Data

1. Right click on the highlighted area (cells A1 --> E2) and select XML --> Import.

2. Locate the XML Report that you generated in Audit Workbench.

Now you have yourself an excel worksheet for FPR results.