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.
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 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.
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.
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.
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.
Right click on the highlighted area (cells A1 --> E2) and select XML --> Import.
Locate the XML Report that you generated in Audit Workbench.
Now you have yourself an excel worksheet for FPR results.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With