SQL Report

Hi there,

I am struggling to put together a report that houses the following requirements:
Top 10 vulnerabilities - So limit to 10 vulnerabilities in descending order with the below information in the columns.
Vulnerability age (date published)
Asset tags
Number of risks/vulnerabilities
affected assets
risk scores

From what I gather, I should be able to use the fact of fact_asset_vulnerability_finding
No matter what I try I can’t seem to get the solution into the report.

I’ve tried going through the SQL information within the SQL GitHub instance but can’t seem to piece it together.

Any help would be greatly appreciated.

Check out the Rapid7 GitHub,