Data warehouse tables missing console database tables

InsightVM SQL Queries
1

Running SQL queries in the Security Console is very tedious, especially since upgrading postgresql. I believe we can get much better reporting and custom trend analysis from a separate database.

I tried to export the data to a Data warehouse but not all tables are being synced.

  1. Why NOT??
  2. Is it in the roadmap to have a full DB export including all tables?
  3. or is there a work around how I can have a full DB export?
  4. Should I rather log a support ticket?

thanks

2

Which tables are not syncing? There are two different schemas for each DB.

DataWarehouse Schema - Dimensional Data Warehouse Schema

Console SQL Reporting schema - Understanding the reporting data model: Overview and query design | InsightVM Documentation

3

fact_asset_vulnerability_age table doesn’t sync to Data warehouse.