Find the assets with Obsolete software

I Tried to find hosts with Obsolete log4j software on them. I hitting a dead-end.

I am using the data warehouse the queries.

You will need to of course add in whatever other columns you want to display in addition to those listed but this should get you what you want.

SELECT da.ip_address, dv.title

FROM fact_asset_vulnerability_finding favf

JOIN dim_asset da USING(asset_id)
JOIN dim_vulnerability dv USING(vulnerability_id)
JOIN dim_vulnerability_category dvc USING(vulnerability_id)

WHERE dvc.category_name = 'Obsolete Software'
AND dv.title like '%log4j%'

Than You John for the response. Unfortunately I couldn’t find category_name = ‘Obsolete Software’

Can you explain what you mean by you couldn’t find it?

Did you run the query and get no results or was there an error that the system generated?