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]

Yes, the file exists. But in an other path.

32bit system: C:\Program Files\...
64bit system: C:\Program Files (x86)\...

[Hemoco]

scsu wrote:
Yes, the file exists. But in an other path.

32bit system: C:\Program Files\...
64bit system: C:\Program Files (x86)\...

You will need to add the other path to the list of files to scan.

[Hemoco]

Does the file %fssm32.exe% exists on the 64 bit machines?