Notify me when asset with this Serial # is found online.

[jboro]

Hello, I am currently demoing Lansweeper and I like it so far. I was wondering if it is possible to set a rule up to find a missing device? Something like, send me an email when a device with a certain serial number or mac address is found on the network. If so, how and where would I go to set this up.


Thanks
Joe

[Daniel_B · Accepted solution]

Lansweeper won't send out email alerts as immediate reaction of changes detected during scanning, but you are able to set up a report which lists assets having the Mac address or serial numbers you are looking for and set up email alerts based on a weekly schedule. For details on how to set up email alerts, please refer to this KB article. Please find an example report below.

Please use the report below for the information you are after. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
- Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Select Top 1000000 tblAssets.AssetID,
   tblAssets.AssetName,
   tblAssets.Domain,
   tblAssets.Username,
   tsysAssetTypes.AssetTypename,
   tsysAssetTypes.AssetTypeIcon10 As icon,
   tblAssets.IPAddress,
   tblAssets.Lastseen,
   tblAssets.Lasttried,
   tblAssets.Mac,
   tblAssetCustom.Serialnumber
 From tblAssets
   Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
   Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
 Where (tblAssets.Mac In ('01:23:45:67:89:AB', '01:23:45:67:89:AC',
     '01:23:45:67:89:AC') Or tblAssetCustom.Serialnumber In ('ABC1234',
     'ABC1235', 'ABC1236')) And tblAssetCustom.State = 1
 Order By tblAssets.Lastseen Desc