Asset Vulnerability age

InsightVM
,
1

Team, Need Customized report for each vulnerability age report. for example asset name : test1 - 160 days. (Total date require)

2 
SELECT 
	da.host_name
	,dv.title
	,fava.age_in_days
FROM fact_asset_vulnerability_age fava
JOIN dim_asset da ON fava.asset_id = da.asset_id
JOIN dim_vulnerability dv ON fava.vulnerability_id = dv.vulnerability_id

More asset information can be added from dim_asset Understanding the reporting data model: Dimensions | InsightVM Documentation

More vulnerability information can be added from dim_vulnerability Understanding the reporting data model: Dimensions | InsightVM Documentation

1 Like
3

My humble experience with fava is that the age is incorrect and capped by the data retention period.
I found the correct age only in the csv export template.

If you find the correct information in any table accessible via the “SQL” queries, I’ll be happy to discover.

tx in advance