‎10-09-2012 06:10 PM
‎10-12-2012 12:48 PM
Select Top 1000000 tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.Lasttried, tblComputers.Lasttriggered, tblComputers.LastScheduled, tblComputers.LastActiveScan, tsysASDomains.Servername, tsysASDomains.Domainname, tsysASDomains.Netbiosname, tsysASDomains.Firsttime, tblComputers.LastLsPush, tblComputers.Scanserver, Web40OSName.OSname, Web40OSName.SP, Web40OSName.OScode, tblerrors.CFGname, tblerrors.ErrorText, tblerrors.Lastchanged From tblComputers Left Join tsysASDomains On tsysASDomains.Netbiosname = tblComputers.Domain Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblerrors On tblComputers.Computername = tblerrors.Computername Order By tblComputers.ComputerUnique
‎10-10-2012 03:32 PM
‎10-10-2012 05:14 PM
Lansweeper wrote:
Only newly logged on machines that have not been scanned in the last 20 hours are added to the scanning queue by Active Scanning.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now