List of Lansweeper scanning servers

[Susan_A]

The report below lists machines that have the Lansweeper Server service installed (i.e. scanning servers) and whose service has connected to your Lansweeper database in the last 7 days. Note that this report may list some non-scanning servers as well. Scanning servers are solely identified based on NetBIOS name, so a machine that has the same NetBIOS name as a scanning server will be identified as a scanning server as well.

The report will only list assets that meet all of the following criteria:

• The asset is a Windows computer.
  
• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.
  
• The computer is listed in the Current Version section of the following Lansweeper webpage: Configuration\Your Lansweeper License. This section lists your installation's web server as well as scanning servers.
  
• The computer's Lansweeper Server service has connected to your database in the last 7 days.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tsysASServers.Servicelastpolled
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tsysASServers On tsysASServers.Servername = tblAssets.AssetName
Where tsysASServers.Servicelastpolled > GetDate() - 7 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName