Team, Need Customized report for each vulnerability age report. for example asset name : test1 - 160 days. (Total date require)
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
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