Generate Report with CVE ID

[bbh537tp]

I am simply attempting to create a report that pulls the CVE-ID. Currently, I can only pull CVE-ID that includes other information in the same column, e.g. Microsoft CVE-2023-36884 or Microsoft CVE-2023-36884 Windows Search Security Feature Bypass Vulnerability.

[bradpjaxx]

see if this is the same thing you are looking for, if its for the Warehouse it should work based on your question, if not and your doing it in the NeXpose SQL report export it will be differnt, and would need some modification.

Data warehouse sql query check

ok well then lets try to Use a LEFT JOIN to dim_vulnerability_reference — not a regular (inner) join and Remove dvr.source IN (‘CVE’, ‘NVD’) from the WHERE clause , or it undoes the outer join, then we can prioritize CVE/NVD sources if you want only one reference. SELECT da.host_name AS "Asset Name", dvr.reference AS "CVE ID", dv.nexpose_id AS "Vulnerability ID", dv.title AS "Vulnerability Title" FROM dim_asset da JOIN fact_asset fa ON da.asset_id = fa.asset_id JOIN fact_asset_vu…