All Collections
Connectors
Vulcan Connectors
Uploading a Penetration Test (PT) Report
Uploading a Penetration Test (PT) Report

Learn how to use the Vulcan Report connector for uploading penetration tests

Updated over a week ago

About

The Vulcan ConnectX/Report Connector enables you to upload CSV, ZIP, XLS, and XLSX files from SAST/DAST and Vulnerability assessment tools that might not be supported yet by the existing Vulcan Connectors. On top of that, you can use the Vulcan Report Connector to upload Penetration Test files for asset data type Host or Website, depending on PT application type or infrastructure. Once you upload your data file and select the appropriate data type, the relevant mapping table appears on the connector screen. Then, you need to map the Headers in your file to the right Header/Field in the Vulcan Platform.

Connector Details

Supported file formats: CSV, ZIP, XLS, and XLSX
Max file size: 200 Mb
File structure: The first row must contain headers.

Uploading a Penetration Test (PT) Report

Depending on the PT application type or infrastructure, you can use the Vulcan Report Connector to upload Penetration Test files for asset data type Host or Website.

  1. Go to Connectors > Add a Connector

  2. Click the Vulcan Report /ConnectX icon

  3. Give your Vulcan Connector an indicative name. This way, you can identify what this report represents.

    For example, "Penetration Test".

  4. Browse or drag and drop the file you wish to upload (CSV, XLS, XLSX).

    Mandatory column headers:

    • Application/Asset Name

    • Severity (numeric)

    • Vulnerability Name (finding)

    • Vulnerability Description

    • Vulnerability Details

    • Test Date

    Optional column header:

    • Mitigation/Solution

    Notes:

    File Example:

  5. For Data Type, select Host (Vulnerability Assessment) or Website (DAST), depending on PT application type or infrastructure.

  6. Once you select the Data Type, a dedicated Map Fields configuration is opened. Map the headers fields in your file (left column) to the respective Vulcan fields (right column). You can also add custom values. For reference, you can review the complete list of optional fields mapping of Websites (DAST) and Hosts (Vulnerability Assessment).

    For example:

    Notes:

    • The Vulcan fields 'Asset - Details' and 'Vulnerability - Details' can be mapped to multiple headers.

    • When mapping a risk score to the Vulcan field "Vulnerabilities - Technical Severity", the mapped risk score represents the score of a Unique Vulnerability in the Vulcan Platform. The risk score of a vulnerability instance is calculated after the file is loaded. The score of a vulnerability instance is determined by all the risk-affecting factors configured in the Vulcan Platform, such as Asset tags and impact. Read here about vulnerability instance risk calculation and how it works.

    • Date fields must be in the date format: DD/MM/YYYY. For example, 20/03/2023.

  7. Click Create

That's it! Your records are now in the Vulcan Platform.


FAQ

How can I convert technical severity to numerics in Excel?

You can use the following excel macro to convert technical severity to numerics:

Sub ConvertSeverityToNumber()
Dim ws As Worksheet
Dim lastRow As Long
Dim severityRange As Range
Dim cell As Range

' Define the severity mappings
Dim severityMap As Object
Set severityMap = CreateObject("Scripting.Dictionary")
severityMap("Critical") = 100
severityMap("High") = 90
severityMap("Medium") = 50
severityMap("Low") = 30

' Set the worksheet where the data is located
Set ws = ThisWorkbook.Worksheets("Sheet1") ' Replace "Sheet1" with your actual sheet name

' Find the last row in the "Severity" column
lastRow = ws.Cells(ws.Rows.Count, "D").End(xlUp).Row ' Assuming "Severity" is in column D

' Set the range for the "Severity" column
Set severityRange = ws.Range("D2:D" & lastRow) ' Assuming the data starts from row 2

' Loop through each cell in the range and convert the text to numerical values
For Each cell In severityRange
If severityMap.Exists(cell.Value) Then
cell.Value = severityMap(cell.Value)
End If
Next cell
End Sub

Did this answer your question?