SQL example - asset count

This example query returns how many assets you have.

sql
1
SELECT COUNT(*) FROM (
2
3
SELECT DISTINCT da.ip_address
4
5
FROM dim_asset da) s

This query returns unique IP addresses, not unique asset IDs.