This my first foray into SQL so bear with me.
I am looking to create a report based on vulnerability that tells me what hosts have been patched and those that are not patched how long they have been unpatched.
This is the query that I stitched together:
> SELECT favf.vulnerability_id, favf.asset_id, da.ip_address, da.host_name, fava.first_discovered, fava.age_in_days, dv.title, favrd.date
> FROM fact_asset_vulnerability_finding favf
> JOIN fact_asset_vulnerability_remediation_date favrd ON favf.asset_id = da.asset_id
> JOIN dim_asset da ON favf.asset_id = da.asset_id
> JOIN dim_vulnerability dv ON favf.vulnerability_id = dv.vulnerability_id
> JOIN fact_asset_vulnerability_age fava ON favf.vulnerability_id = fava.vulnerability_id
> WHERE dv.title LIKE ‘%CVE-2020-16947%’
its failed with the following error:
Error: relation “fact_asset_vulnerability_remediation_date” does not exist
More than anything I am intrigued by fact_asset_vulnerability_remediation_date not existing. Am I not calling upon it right?