SQL Query Example: Asset Count

Document created by synapsr on Feb 5, 2015
Version 1Show Document
  • View in full screen mode

Sometimes all you want to know is how many assets you have.  Well, there is a query for that

 

SELECT COUNT(*) FROM (

SELECT DISTINCT da.ip_address

FROM dim_asset da) s

2 people found this helpful

Attachments

    Outcomes