Vulnerability Report for Application & OS Based

Hi All,
Is it possible to segregate Vulnerability report for Applications & Operationg System Based using SQL query with all the necessary details for the report. Can someone in the group please suggest. Thanks in Advance !!

We don’t really have anything for Application or Software based stuff but you could use the below query to get a start for OS based reporting.

SELECT
fa.vulnerabilities,
da.ip_address,
da.host_name,
dos.description

FROM fact_asset fa

JOIN dim_asset da ON fa.asset_id=da.asset_id
JOIN dim_asset_operating_system daos ON fa.asset_id=daos.asset_id AND da.asset_id=daos.asset_id
JOIN dim_operating_system dos ON daos.operating_system_id=dos.operating_system_id

GROUP BY
fa.vulnerabilities,
da.ip_address,
da.host_name,
dos.description
1 Like