cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ifm
Champion Sweeper
I would like a report where I can see all network swiches that does not respond to ping (=offline).
This report would be on my dashboard and also used with email alarm.

I probably want to use a similar report for printers, projectors, ups etc.

Thank you in advance!
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
A function for scheduled pings is not currently available as Lansweeper was designed as an inventory management tool.
What you could do is to
  • under Configuration\Scanning methods, section IP Address Range Scanning, set up a schedule for daily scanning of your switches
  • Create a report like the following, which lists switches which haven't been successfully scanned for more than 1 day. If you would like to use it for other asset types, change the filter on tsysAssetTypes.AssetTypename.

    Select Top 1000000 tblAssets.AssetID,
    tblAssets.AssetName,
    tsysAssetTypes.AssetTypename,
    tsysAssetTypes.AssetTypeIcon10 As icon,
    tblState.Statename As State,
    tblAssets.IPAddress,
    tblAssets.Lastseen,
    tblAssets.Lasttried,
    tblErrors.ErrorText,
    tsyserrortype.Errorname
    From tblAssets
    Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
    Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
    Inner Join tblState On tblAssetCustom.State = tblState.State
    Left Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
    Left Join tsyserrortype On tblErrors.ErrorType = tsyserrortype.ErrorType
    Where tsysAssetTypes.AssetTypename Like 'switch' And tblAssets.Lastseen <
    GetDate() - 1 And tblAssetCustom.State = 1

  • Set up an email alert with this report. For details on email alerts, please refer to this KB article.

View solution in original post

2 REPLIES 2
ifm
Champion Sweeper
Thank you!

I have set up a scheduled scan for our mgmt-network (where the switches can be accessed) every hour. We also have Nagios to alert us, but I wanted to add a similar report in Lansweeper.
Daniel_B
Lansweeper Alumni
A function for scheduled pings is not currently available as Lansweeper was designed as an inventory management tool.
What you could do is to
  • under Configuration\Scanning methods, section IP Address Range Scanning, set up a schedule for daily scanning of your switches
  • Create a report like the following, which lists switches which haven't been successfully scanned for more than 1 day. If you would like to use it for other asset types, change the filter on tsysAssetTypes.AssetTypename.

    Select Top 1000000 tblAssets.AssetID,
    tblAssets.AssetName,
    tsysAssetTypes.AssetTypename,
    tsysAssetTypes.AssetTypeIcon10 As icon,
    tblState.Statename As State,
    tblAssets.IPAddress,
    tblAssets.Lastseen,
    tblAssets.Lasttried,
    tblErrors.ErrorText,
    tsyserrortype.Errorname
    From tblAssets
    Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
    Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
    Inner Join tblState On tblAssetCustom.State = tblState.State
    Left Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
    Left Join tsyserrortype On tblErrors.ErrorType = tsyserrortype.ErrorType
    Where tsysAssetTypes.AssetTypename Like 'switch' And tblAssets.Lastseen <
    GetDate() - 1 And tblAssetCustom.State = 1

  • Set up an email alert with this report. For details on email alerts, please refer to this KB article.