Hi, I’m trying to get the asset history for devices via a SQL query. This is the data shown in an asset page, right below the scan history section but I’m unable to find it.
There’s nothing obvious in the documentation Understanding the reporting data model: Dimensions | InsightVM Documentation and I’ve tried also checking the Data Warehouse schema (even though we don’t have one) to see if I can ‘reverse-engineer’ it, but can see anything there.
(The reason for this is that I’ve discovered we have devices that should be being scanned by an engine regularly, but were actually last scanned years ago and then just stopped being detectable for some reason, so the currently displayed data for services and ports is years old. The systems also have the agents which is why they haven’t been purged - if anybody has a better way than what i’m trying above to identify systems that exist but were last scanned by a scan engine years ago then that would be great!)
Thanks