‎04-13-2021 03:44 PM
‎04-14-2021 11:31 AM
Select Top 1000000 tsysAssetTypes.AssetTypename,
Count(tblAssets.AssetID) As Total,
tblState.Statename
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tsysAssetTypes.AssetTypename Not Like 'Monitor'
Group By tsysAssetTypes.AssetTypename,
tblState.Statename
Order By tsysAssetTypes.AssetTypename,
tblState.Statename,
Total Desc
‎04-13-2021 05:04 PM
‎04-13-2021 03:56 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now