OS: Not latest services pack Win2008 R2

[creinking]

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!

[creinking]

Thank you very much!

[Hemoco]

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