cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MilicaM
Engaged Sweeper II
Hi,

I have an alert displayed on Lansweeper web console: "License Warning | Your license is limited to 5000 assets. You've reached 95%".

Is there a possibility to receive this warning over an email? And when the assets count is below 95% no email warning is received.

Thank you,
Milica
4 REPLIES 4
MilicaM
Engaged Sweeper II
Hey Esben, thanks for noticed it, but I already put the filter with:

Where tblAssets.AssetUnique Not Like 'Mon:%' 🙂

Milica
Esben_D
Lansweeper Employee
Lansweeper Employee
You will still have to take into account that Monitor assets are not counted towards the license. So you will have to slightly adjust your report.
MilicaM
Engaged Sweeper II
Hi Esben,

Many thanks for your reply!

I already found solution:

Select Top 1000000 Count(tblAssets.AssetID) As [Asset count],
5000 As [Asset limit],
Cast(Cast(Count(tblAssets.AssetID) As float) / 5000 * 100 As decimal(8,2)) As
[% used]
From tblAssets
Where tblAssets.AssetUnique Not Like 'Mon:%'
Having Cast(Cast(Count(tblAssets.AssetID) As float) / 5000 * 100 As
decimal(8,2)) >= 95

Where 5000 is asset limit.

Regards,
Milica
Esben_D
Lansweeper Employee
Lansweeper Employee
You could create a report about it and use it in a report alert:

Select Top 1000000 Cast(Count(SQ1.AssetID) * 100.0 / 5000 As Decimal(10,2)) As
[%]
From tblAssets
Left Join (Select tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType =
tblAssets.Assettype
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblState.Statename != 'monitor') As SQ1 On SQ1.AssetID =
tblAssets.AssetID
Having Cast(Count(SQ1.AssetID) * 100.0 / 5000 As Decimal(10,2)) >= 95