Need to get the CVE ID into my data warehouse query and have been running into the following…
Using dvr.reference AS “Vulnerability CVE IDs” column and then dvr.source = ‘CVE’::text OR dvr.source = ‘NVD’::text OR dvr.source = ‘*’ added to the where statement.
What I am finding is that if there’s no associated vulnerability CVE ID, then it won’t show the vulnerability in the report at all. How can I fix this?