SQL example - asset count
This example query returns how many assets you have.
sql
1SELECT COUNT(*) FROM (23SELECT DISTINCT da.ip_address45FROM dim_asset da) s
This query returns unique IP addresses, not unique asset IDs.
Did this page help you?