→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
creinking
Engaged Sweeper
I accidentally broke the query when I was adding location and now this report doesn't run. Can anyone just simply post the original report sql query here? Thanks!
2 REPLIES 2
creinking
Engaged Sweeper
Thank you very much!
Hemoco
Lansweeper Alumni
You can recreate the report as follows:


View name
netlatestSP2008R2

Report name
OS: Not latest Service Pack Win2008 R2

SQL query
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, tblOperatingsystem.ServicePackMajorVersion As [Current SP], tblComputers.Lastseen, Web40OSName.Compimage As icon 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 2008 R2' And tblOperatingsystem.ServicePackMajorVersion <> '1' Order By dbo.tblComputers.Computer