Report results are different in Lansweeper Configuration and on the website

[physh]

Hi,

I have the following report that runs fine in the Configuration Utility but once I run in on the lansweeper website, some results don't show up:

SELECT TOP 1000000 dbo.tblComputers.Computer As Hostname,   dbo.tblComputers.Username, tblComputerSystemProduct.Name As Model,   tblOperatingsystem1.Caption As [Operating System],   tblOperatingsystem.ServicePackMajorVersion As [Service Pack],   dbo.tblBIOS.SMBIOSBIOSVersion As [BIOS  Version], dbo.tblComputers.LastknownIP   As [Last Known IP], tblOperatingsystem.InstallDate As [OS Install Date],   dbo.tblComputers.LastActiveScan As [Last  Seen] From dbo.tblComputers Inner   Join dbo.tblBIOS On dbo.tblComputers.Computername = dbo.tblBIOS.Computername   Inner Join tblComputerSystemProduct On dbo.tblComputers.Computername =   tblComputerSystemProduct.Computername Inner Join tblOperatingsystem On   dbo.tblComputers.Computername = tblOperatingsystem.Computername Inner Join   tblOperatingsystem tblOperatingsystem1 On dbo.tblComputers.Computername =   tblOperatingsystem1.Computername Order By dbo.tblComputers.Username

For some reason computers with OperatingSystem.InstallDate prior to 2010 won't show up at all.

[physh]

Much better thanks. It still seems like the row ordering doesn't work properly with dates, do you see the same?

[AdmJLovejoy]

Try this

Select Top (1000000) tblComputers.Computer As Hostname, tblComputers.Username,
  tblComputerSystemProduct.Name As Model, tblOperatingsystem1.Caption As
  [Operating System], tblOperatingsystem.ServicePackMajorVersion As
  [Service Pack], tblBIOS.SMBIOSBIOSVersion As [BIOS Version],
  tblComputers.LastknownIP As [Last Known IP], tblOperatingsystem.InstallDate As
  [OS Install Date], tblComputers.LastActiveScan As [Last Seen]
From tblComputers Inner Join
  tblBIOS On tblComputers.Computername = tblBIOS.Computername Inner Join
  tblComputerSystemProduct On tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblOperatingsystem On tblComputers.Computername =
    tblOperatingsystem.Computername Inner Join
  tblOperatingsystem As tblOperatingsystem1 On tblComputers.Computername =
    tblOperatingsystem1.Computername Inner Join
  web40ActiveComputers On web40ActiveComputers.Computername =
    tblComputers.Computername
Order By tblComputers.Username