OID Lookup: Asset Count (Built-in)

[Esben_D]

The report below gives back a count of assets scanned per custom OID.

The report will only list OIDs when the following criteria are met:

• You have Lansweeper 7.0 or higher.
  
• There are custom OID scans configured.

Select Top 1000000 'node-design.png' As Icon,
  uniquedata.Label As [OID Label],
  uniquedata.[Key] As OID,
  Count(uniquedata.AssetID) As [Asset Count]
From (Select Distinct Top 1000000 'node-design.png' As Icon,
        tblOIDData.Label,
        tblOIDData.[Key],
        tblAssets.AssetID
      From tblOIDData
        Inner Join tblAssets On tblAssets.AssetID = tblOIDData.AssetID)
  uniquedata
Group By uniquedata.Label,
  uniquedata.[Key]