cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Emort
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

16 REPLIES 16
Emort
Engaged Sweeper
Lansweeper wrote:
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.

ahhhh!
so i add this to the "scanned files" tab:
%programfiles%\F-Secure\Anti-Virus\fsav.exe

changed the report to '%fsav%'
and then restart the lansweeper service to get a new scan,
waited to all the scannes was done, then the web service.

no output?
Hemoco
Lansweeper Alumni
This is an example report that uses the scanned file '%fssm32%'
If you don't scan this file or don't use f-secure you can safely remove the report.
Emort
Engaged Sweeper
Lansweeper wrote:
This is an example report that uses the scanned file '%fssm32%'
If you don't scan this file or don't use f-secure you can safely remove the report.


eh then i misunderstod the overall setup, sorry
how can i get started scanning for f-secure then .
Hemoco
Lansweeper Alumni
Could you give me the sql definition of the report please.
Emort
Engaged Sweeper
Lansweeper wrote:
Could you give me the sql definition of the report please.

it is the standart report

Select Top 100 Percent 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 Collate Latin1_General_CI_AS Where dbo.tblFileVersions.FilePathfull Like '%fssm32%' And dbo.tblFileVersions.Found = 0 And dbo.tblComputersystem.Domainrole = '1' Order By dbo.web30repdomainswithfsecure2.Domain, dbo.tblFileVersions.Lastchanged Desc
Hemoco
Lansweeper Alumni
Do you scan for this file using the file scanning?
Emort
Engaged Sweeper
Lansweeper wrote:
Do you scan for this file using the file scanning?

not sure what you saying, the report is showing all servers and workstations have fsecure but
if i take a machine that i know is in the list and tjek for installed software there is none, if i on the machine go to a cmd and search for fsecure there is none, never has been :-d