SQL example - asset discovery
This example query will provide you with the following:
- Asset IP Address
- Asset Hostname
- Asset MAC Address
- Asset First Discovered Date
- Asset Last Discovered Date
sql
1SELECT da.ip_address, da.host_name, da.mac_address, fad.first_discovered, fad.last_discovered2FROM fact_asset_discovery fad3JOIN dim_asset da USING (asset_id)
Did this page help you?