Issue with Creating a Report

[AlexGP]

Hi,

I am having trouble creating a report. The SQL statement I use for it has been tested in SQL Studios and the Lansweeper ReportBuilder and it worked in both. I have created a view in the DB which worked also. But when I go into the configuration tool and setup the report, I receive a Runtime Error. Below is my SQL statement.

SELECT     Web30LastLogon2.lastuser AS [User], tblComputers.Computername AS Computer, tblComputers.Domain, tblSoftware.softwareName AS Software
FROM         tblComputers INNER JOIN
                      tblSoftware ON tblComputers.Computername = tblSoftware.ComputerName INNER JOIN
                      Web30LastLogon2 ON tblComputers.Computername = Web30LastLogon2.Computername
WHERE     ((tblSoftware.softwareName LIKE 'Napster%')  AND NOT(tblSoftware.softwareName LIKE 'Napster for Windows Media Player%')) OR 
				((tblSoftware.softwareName LIKE 'AIM%') AND NOT(tblSoftware.softwareName LIKE 'AIM Toolbar%')) OR
				(tblSoftware.softwareName LIKE 'AOL Instant Messenger%') OR
				(tblSoftware.softwareName LIKE 'Azureus%') OR
				(tblSoftware.softwareName LIKE 'Disney%') OR
				(tblSoftware.softwareName LIKE 'Google Talk%') OR
				(tblSoftware.softwareName LIKE 'MSN Messenger%') OR
				(tblSoftware.softwareName LIKE 'Pirate Poppers%') OR
				(tblSoftware.softwareName LIKE 'Skype%') OR
				(tblSoftware.softwareName LIKE 'Windows Live Messenger%') OR
				(tblSoftware.softwareName LIKE 'World of Warcraft%') OR
				(tblSoftware.softwareName LIKE 'Yahoo! Messenger%') OR
				(tblSoftware.softwareName LIKE 'BitTorrent%') OR
				(tblSoftware.softwareName LIKE 'BitComet%') OR
				(tblSoftware.softwareName LIKE 'KTorrent%') OR
				(tblSoftware.softwareName LIKE 'uTorrent%')

Thanks for any help.

[AlexGP]

Thanks.

That fixed the issue.

[AlexGP]

I check and the configuration utility is version 3.5.1.13. Doesn't that mean I already have it installed?

[Hemoco]

AlexGP wrote:


I check and the configuration utility is version 3.5.1.13. Doesn't that mean I already have it installed?

The configuration utility was updated earlier because of a hotfix.

Your service version should be : 3.5.1.28957

[Hemoco]

Please download the 3.5.1 package from the website, it will solve the problem.

[Hemoco]

Is the error related to the "version" field?
This error was fixed in 3.5.1

[AlexGP]

Lansweeper wrote:
Is the error related to the "version" field?
This error was fixed in 3.5.1

Error Details:
Column 'version' does not belong to table theTable.
Exception Details: System.ArgumentException: Column 'version' does not belong to table theTable.

We are currently using version 3.5.3366.20178.