SELECT da.ip_address, da.host_name, da.mac_address, fad.first_discovered, fad.last_discovered
FROM fact_asset_discovery fad
JOIN dim_asset da USING (asset_id)
Attempting to added just plain and simple owner tag to this so owner tags pop up and custom tags so i see which ones have been discovered with tags already on them…All other inqueries are so complicated that have the owner tag incorporated…
Any way we can add custom tag and owner to this simple query?