Simple "server offline" check

[Watso]

Hi all,

New user here, really liking the asset scanning and hoping I can utilize this for some very simple server alerts should they go offline since the last scan.

Has anyone developed such a "report" that I can setup an email alert on perhaps?  I must admit the only thing I find difficult is report building, I'm not great with databases and most of the tools I've used in the past had much friendlier report editing without dealing with tables and joins, etc.  Even if I have to tweak it a bit I'd be very appreciative if someone has already come up with something like that!

Or maybe I'm missing something in the built-in reports?

Thanks all!

[Obi_1_Cinobi]

Hello there!

Lansweeper is not a real-time monitoring tool but an inventory tool, but you can use the following workaround as you suggest.

Setup our report alert functionality as documented in this KB article: https://www.lansweeper.com/knowledgebase/sending-email-alerts/

Then, do the following:

• First, create an asset group containing the servers you want to monitor. An asset group can be any built-in (or custom) static or dynamic group. More information on grouping assets can be found here: https://www.lansweeper.com/knowledgebase/grouping-assets/
• Next, you set up a scanning target for the newly created asset group under Scanning\Scanning Targets, and there you can specify the scan schedule in minutes e.g. 15 minutes. You can go as low as one minute. You can refer to this article for more info: https://www.lansweeper.com/knowledgebase/scanning-with-asset-collection-scanning/
• We've included a sample report below that you can add to your Lansweeper installation, which will report on all servers in the specified asset group which were not successfully scanned in the past 15 minutes. You'll just need to fill in the name of the asset group and you can change the number of minutes.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  DateDiff(mi, tblAssets.Lastseen, GetDate()) As LastSeenXMinutesAgo,
  tblAssetGroups.AssetGroup
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
    tblAssetGroupLink.AssetGroupID
Where DateDiff(mi, tblAssets.Lastseen, GetDate()) > 15 And
  tblAssetGroups.AssetGroup = 'My asset group' And tblAssetCustom.State = 1
Order By LastSeenXMinutesAgo Desc