cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Susan_A
Lansweeper Alumni
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
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now