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
1
SELECT da.ip_address, da.host_name, da.mac_address, fad.first_discovered, fad.last_discovered
2
FROM fact_asset_discovery fad
3
JOIN dim_asset da USING (asset_id)