cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jim_barr
Engaged Sweeper II
Lansweeper currently scans multiple subnets, one of which is an "infrastructure" subnet for network switches and access points. Is it possible for Lansweeper to scan at a somewhat frequent interval (say, every 15-30 minutes or whatever) and if a device fails to scan, send an email notification?
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
Possible: Yes

Implementation wise it's not as straight forward. You need a report that shows all assets for which the "Last tried" is in the past 15-30 minutes (depending on your interval) and only shows assets from your infrastructure subnet.
You can then schedule this report to be emailed every 15-30 minutes. Reports are only emailed when they are not empty.

This way if any asset fails to get scanned, you will get an email with the report including that device. You can use the report below as a starting point. You might have to adjust the interval (set to 30min in the report) and add the criteria to only select your subnet.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.Lastseen <> tblAssets.Lasttried And tblAssets.Lasttried >=
DateAdd(minute, -30, GetDate()) And tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName