cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

OID Lookup: Asset Count (Built-in)

Esben_D
Lansweeper Employee
Lansweeper Employee
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]
0 REPLIES 0