Problems wit Report

[melsner]

Hello
I just got a Problem trying to edit 2 Reports.

Report 1 " AVG Antivirus installed "
Invalid Token ´Collate at Position 595 at Line 1`

Report 2 " No F-Secure installed
Invalid Token ´Collate at Position 734 at Line 1`

every other Report workt fine.
Did anybody has an Idea?

[Hemoco]

You can just delete these reports (they were included in 3.2)

[Hemoco]

We cannot reproduce the problem.

Anyone else with this issue?

[dbowman]

Lansweeper wrote:
We cannot reproduce the problem.

Anyone else with this issue?

I have the same issue: my setup is 3.5.1, upgraded from 3.5, upgraded from 3.2. I never tried this on 3.2 but on 3.5 it was not working

These are the SQL queries

NoFSecure (which reports nothing if run into SQL Analyzer but I have no FSecure installed anywhere)

SELECT
dbo.tblComputers.Computername AS Computer,
dbo.tblOperatingsystem.Description,
dbo.web30repdomainswithfsecure2.Domain,
dbo.tblFileVersions.Lastchanged
FROM
dbo.tblComputers
INNER JOIN dbo.tblComputersystem ON (dbo.tblComputers.Computername = dbo.tblComputersystem.Computername)
INNER JOIN dbo.web30repdomainswithfsecure2 ON (dbo.tblComputers.Domain = dbo.web30repdomainswithfsecure2.Domain)
LEFT OUTER JOIN dbo.tblOperatingsystem ON (dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername)
LEFT OUTER JOIN dbo.tblFileVersions ON (dbo.tblComputers.Computername = dbo.tblFileVersions.Computername)



AVG (which reports all my computers if run into SQL Analyzer, none of them with avg installed)

SELECT
dbo.tblComputers.Computername AS Computer,
dbo.tblOperatingsystem.Description,
dbo.tblFileVersions.FilePathfull,
dbo.tblFileVersions.Lastchanged
FROM
dbo.tblComputers
INNER JOIN dbo.tblComputersystem ON (dbo.tblComputers.Computername = dbo.tblComputersystem.Computername)
LEFT OUTER JOIN dbo.tblOperatingsystem ON (dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername)
LEFT OUTER JOIN dbo.tblFileVersions ON (dbo.tblComputers.Computername = dbo.tblFileVersions.Computername)

[melsner]

The original Version was 3.2 but I had the same Problem on that Version.

[Hemoco]

The queries work without any problems.
What was your original lansweeper version? (the version that you installed first)
It might be a problem with the tables that changed afterwards.

[melsner]

Sorry it took my so long

here are the 2 SQL Scripts.

[Hemoco]

Could you post the sql code of these 2 reports please.

[melsner]

We updated from 3.2 but the problem was the same under 3.2

[Hemoco]

Did you do an upgrade from a previous version?