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

Names Bob and I'm new to LANsweeper. We are a small VoIP company. We want to know when a customers site has gone off-line. We have a couple of things in place for that. One of the things is a PING monitor. It sends a PING to the customers Public IP address every thirty minutes. It will email us when it does a PING and does not get a response. I'd like to know if LANsweeper can be setup to do the same thing? ANy ideas would be greatly appreciated. Thank You again in advance.
1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
A possible solution would be to use the code underneath to create a custom report. The report below will show a list of assets for which the "last seen" time differs from the "last tried" time.
If this time differs, and your scanning credentials are correct, it means that the asset is offline.
Afterwards you can set up an e-mail alert for this report.
Do note that you'll have to set the scanning frequency for this range to scan at least as frequently as the email alert interval. This email will only be sent if the report returns a result.


For instructions on how to add a report to Lansweeper, you can consult this post.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.Lasttried != tblAssets.Lastseen And tblAssetCustom.State = 1


Additionally, if you wish to filter for specific assets, you can assign them to a static asset group under Configuration\Asset Groups. For more information on asset grouping you can consult this article.
You can change what you filter for by editing this part of the code : tblAssetgroup.assetgroup Like 'Test'

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
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 tblAssets.Lasttried != tblAssets.Lastseen And tblAssetCustom.State = 1 And
tblAssetGroups.AssetGroup Like 'Test'

View solution in original post

3 REPLIES 3
IntelYPO
Engaged Sweeper
genius. thanks.
Bruce_B
Lansweeper Alumni
A possible solution would be to use the code underneath to create a custom report. The report below will show a list of assets for which the "last seen" time differs from the "last tried" time.
If this time differs, and your scanning credentials are correct, it means that the asset is offline.
Afterwards you can set up an e-mail alert for this report.
Do note that you'll have to set the scanning frequency for this range to scan at least as frequently as the email alert interval. This email will only be sent if the report returns a result.


For instructions on how to add a report to Lansweeper, you can consult this post.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.Lasttried != tblAssets.Lastseen And tblAssetCustom.State = 1


Additionally, if you wish to filter for specific assets, you can assign them to a static asset group under Configuration\Asset Groups. For more information on asset grouping you can consult this article.
You can change what you filter for by editing this part of the code : tblAssetgroup.assetgroup Like 'Test'

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
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 tblAssets.Lasttried != tblAssets.Lastseen And tblAssetCustom.State = 1 And
tblAssetGroups.AssetGroup Like 'Test'
Juha_Otava
Engaged Sweeper III
Have you tried Paessler PRTG or Uptime Robot or similar?