Is it possible to create a query that finds software in the instance with the most vulnerabilities? I’m looking to track the top 10 most vulnerable softwares in the instance month over month.
Furthest i’ve gotten is:
SELECT
das.name AS “Software Name”,
COUNT(favf.vulnerability_id) AS “Vulnerability Count”
FROM
dim_asset_software das
JOIN
dim_asset da ON das.asset_id = da.asset_id
JOIN
fact_asset_vulnerability_finding favf ON das.asset_id = favf.asset_id
GROUP BY
das.name
ORDER BY
“Vulnerability Count” DESC
LIMIT 10;
However the results do not seem accurate, any help would be appreciated.