Report works with WinXP but not Win7 64bit

[scsu]

Hi!

A report called "No F-Secure installed" helps us to control the numbers of F-Secure installations

It works great with Windows Xp 32bit, but not with Windows 7 64 bit.

Here is the SQL Code


Select Top 1000000 dbo.tblComputers.ComputerUnique, dbo.tblComputers.Computername, dbo.tblComputers.Username, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Description, 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 Where dbo.tblFileVersions.FilePathfull Like '%fssm32.exe%' And dbo.tblFileVersions.Found = 0 Order By dbo.tblFileVersions.Lastchanged Desc

What`s wrong?

Greetings

[scsu]

Tried it, but there are still 20 machines with wrong results. Mostly of them with a 64bit system.

***EDIT***29.10.2010
Well, i restarted the lansweeper service, now it works!

Thank you!

[Hemoco]

try this one

Select Top 1000000 dbo.tblComputers.ComputerUnique,
  dbo.tblComputers.Computername, dbo.tblComputers.Username,
  dbo.tblComputers.Domain, dbo.tblOperatingsystem.Description,
  dbo.tblComputersystem.SystemType                         
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
Where dbo.tblOperatingsystem.Computername Not In (Select
    tblfileversions.Computername From tblfileversions
  Where tblfileversions.FilePathfull Like '%fssm32.exe%' And
    tblfileversions.Found = 1)

[scsu]

Today it looks like the x86 clients work again. But there are still 20 machines, with a wrong result because of two configured scan-directories.


SQL Query:

Select Top 1000000 dbo.tblComputers.ComputerUnique, dbo.tblComputers.Computername, dbo.tblComputers.Username, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Description, dbo.tblFileVersions.Lastchanged, dbo.tblFileVersions.FilePathfull, dbo.tblComputersystem.SystemType 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 Where dbo.tblFileVersions.FilePathfull Like '%fssm32.exe%' And dbo.tblFileVersions.Found = 0 Order By dbo.tblFileVersions.Lastchanged Desc

[Hemoco]

Can you post your latest sql query please.

[scsu]

Both are added. But it looks like lansweeper checks both directories for every machine.

When fssm32.exe is not in both directories, it says = no f-secure installed.

[Hemoco]

You will need to add both in the list of scanned files.

[scsu]

Alright! But since I`ve added the 64bit path, the report only looks under "c:\Program files (x86)" and not the old path ( "c:\programfiles\" )

[Hemoco]

Currently "%programfiles(x86)% is not supported, you will need the full path "c:\program files (x86)\"

[scsu]

I`ve added the 64bit path to the "scanned files". But now, all 32bit Machines say, they have no F-Secure installed (because there is no path like "%programfiles(x86)%

How can I configure the Report, to look in the 32bit path OR in the 64bit path?