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
