I need a SQL for report that brings back on a specific cve, assets, and owner tags so i can make contact please…
I think a good starting point here would be the fact_asset_vulnerability_finding
table. There you can see vulnerability ID’s + affected assets, along with a timestamp for it. Then you could join with dim_tag_asset
for tag purposes, and dim_vulnerability
if you want to filter it by something like the “title” (we call it the Nexpose ID in the DB). An example is “oracle_linux-cve-2016-9445.”