cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RayPamps23
Engaged Sweeper II
We have total of 4000 licenses for Lansweeper and it appears that i've reached 95%(equivalent to 3,800) utilization already. But upon checking on our dashboard it reflects that I only have a total of 3,639(under Dashboard> Hardware>Computer Model Overview) and it doesn't match with the warning message that I'm getting.

My question is, is there a report query that I can use to generate what are those assets that Lansweeper is utilizing?



3 REPLIES 3
Hendrik_VE
Champion Sweeper III
This report gives you the exact license count, grouped by asset type and asset state.

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
RayPamps23
Engaged Sweeper II
thanks Brandon
brandon_jones
Champion Sweeper III
It seems you are only looking at computers. Printer, network switches, computers, etc. all use a license. The only thing that does not use licenses are monitors.

To see what is using a license click the assets link at the top of your web console. The only thing that does not use a license are monitors.

Source: https://www.lansweeper.com/knowledgebase/assets-that-count-towards-your-licensed-asset-limit/