Blank Fields in V 5

[kevinoie]

Hi. Installed the latest version and very happy with it.. Love the new interface. One small issue however, when i run the below report, which ran fine in the previous version, the operating system is blank.

when i go in and edit the report I see the following alert

" Column 'upgrade_tblADComputers.OperatingSystem' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause"

Here is the full code from the original report:

Select Top 1000000 upgrade_tblComputers.Username,
upgrade_tblComputers.Computer,
upgrade_tblADComputers.OperatingSystem,
upgrade_tblComputers.SP,
upgrade_web40CorrectMemory.Memory,
upgrade_tblComputers.LastknownIP,
upgrade_tblSoftware.softwareName As Software,
upgrade_tblSoftware.softwareVersion As Version,
upgrade_tblSoftware.SoftwarePublisher As Publisher,
tblADusers.Office,
tblADusers.Description,
upgrade_tblComputers.Lastseen
From upgrade_tblSoftware
Inner Join upgrade_tblComputers On upgrade_tblSoftware.ComputerName =
upgrade_tblComputers.Computername
Inner Join upgrade_tblADComputers On upgrade_tblComputers.Computername =
upgrade_tblADComputers.Computername
Inner Join tblADusers On tblADusers.Username = upgrade_tblComputers.Username
Inner Join upgrade_web40CorrectMemory
On upgrade_web40CorrectMemory.Computername =
upgrade_tblADComputers.Computername
Group By upgrade_tblComputers.Username,
upgrade_tblComputers.Computer,
upgrade_tblADComputers.OperatingSystem,
upgrade_tblComputers.SP,
upgrade_web40CorrectMemory.Memory,
upgrade_tblComputers.LastknownIP,
upgrade_tblSoftware.softwareName,
upgrade_tblSoftware.softwareVersion,
upgrade_tblSoftware.SoftwarePublisher,
tblADusers.Office,
tblADusers.Description,
upgrade_tblComputers.Lastseen
Having (upgrade_tblSoftware.SoftwarePublisher = 'Symantec Corporation') Or
(upgrade_tblSoftware.SoftwarePublisher = 'Symantec') Or
(upgrade_tblSoftware.SoftwarePublisher = 'norton')
Order By Count(upgrade_tblSoftware.ComputerName) Desc,
upgrade_tblSoftware.softwareName

[Hemoco]

TblADComputers.OperatingSystem no longer exists in Lansweeper 5.0. We recommend adding tblOperatingsystem.Caption to your report instead.