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?