→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
neosys
Engaged Sweeper II
I got all my Win7 Computers up to date with the SP1 but still they show here...

Computer information shows on all win7 PC's
OS: Windows 7 Professional SP1

Groupe Rodeus
1 REPLY 1
Hemoco
Lansweeper Alumni
Please contact us at support@lansweeper.com and provide us with the following:
- The names of a few computers that you feel should not be in the report.
- Output of the query below.

Select Top 1000000 tblComputers.Computername, tblComputers.Domain,
tblComputers.Computer, Web40OSName.OSname,
tblOperatingsystem.ServicePackMajorVersion As [Current SP],
tblComputers.Lastseen
From tblOperatingsystem Inner Join
tblComputers On tblOperatingsystem.Computername = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Where Web40OSName.OSname = 'Win 7'
Order By tblComputers.Computer