SQL Query for asset first found date

We’d like to use the Asset History of an asset to find the first date it was found. However we can’t use the fact_asset_discovery table because we have our Console set to keep only x months of scan data and that limits the Scan History that the fad table seems to reference.

The data we appear to need is in the fact_asset_event table that’s referenced in Dimensional Data Warehouse Schema but you can’t query that table in the Console UI.

Any ideas?

Dimensional Data Warehouse Schema is for the external data warehouse. The console might have a table close to date but I have not seen it.
I just spun up a Data warehouse and query that directly.