No F-Secure installed not working

[Emort]

hello,
i cant seam to get the report "No F-Secure installed " to work, it shows 0 and i know that that is wrong,

i can se that the report i looking for = Like %fssm32%
a sweep of my system finds no fssm32 so why is it showing that alle systems are AV'ed

(dir /s *fssm32*)


any ideas

[Hemoco · Accepted solution]

try this:

Select Top 1000000 dbo.tblComputers.Computername As Computer,
  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 '%fsav.exe%' And
  dbo.tblFileVersions.Found = 0
Order By dbo.tblFileVersions.Lastchanged Desc

[Emort]

hey that worked.?

[Hemoco]

If that is what you want the file scanning is not a good idea.
Better would be to use the table "tblsoftware" and compare it to a list of known antivirus software.

[Emort]

Lansweeper wrote:
If that is what you want the file scanning is not a good idea.
Better would be to use the table "tblsoftware" and compare it to a list of known antivirus software.

hmm lets just get "no f-secure installed" to work.
ikke try to have look at the comparing part another time.

[Hemoco]

Could you give me an example line, I'll create a report for you.

What exactly do you want in the report : "no f-secure installed"?

[Emort]

Lansweeper wrote:
Could you give me an example line, I'll create a report for you.

What exactly do you want in the report : "no f-secure installed"?

sure thing

[2175] [TESTSRV] [0]	 [NULL] [NULL] [NULL] [2010-02-11 10:04:26.123]

all i want is to identity " does the machine have a antivirus installed yes/no
and name of antivirus.
dont know i you can pull a value on "is there a antivirus" else just F-secure.

[Hemoco]

Do you see anything in the table "tblfileversions"

[Emort]

Lansweeper wrote:
Do you see anything in the table "tblfileversions"

yes it is filled.

[Hemoco]

In the configuration tool you can add "scanned files"
All computers are scanned if this file exists and what the version number is.

You can then use this information to build custom reports.