03-05-2019 11:42 AM
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]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now