cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
reggimenti_f
Engaged Sweeper
Hi,
let me explain with a scenario:
i have some installations of MS Project in my network,
i'd like to have a notification when the 31th MS Project is installed

is it possible?

Thank you
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
It is. You can use scheduled report alerts for this and by using the report below. This should give you a notification when the amount of scanned installation are 31 or higher. Do note you will have to replace YourSoftware with the exact name given to MS Project in Lansweeper.

More information on how to create a report alert can be found here: https://www.lansweeper.com/kb/113/sending-email-alerts.html

Also note that if Lansweeper has not yet scanned the asset with the software, the count will not be accurate.

Select Top 1000000 Count(tblAssets.AssetID) As CountInstalled,
tblSoftwareUni.softwareName As Software
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName = 'YourSoftware'
Group By tblSoftwareUni.softwareName
Having Count(tblAssets.AssetID) >= 31
Order By Software

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now