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?