Change F-Secure to TrendMicro

[tellis]

How do I change the anti-virus check from F-Secure to TrendMicro OfficeScan??

[Hemoco]

In the reportbuilder you need to create a link between the 2 tables (between the "computername" fields")

This should be the correct result:

Select tblFileVersions.Found, tblFileVersions.FilePathfull,
  tblComputers.Computername
From tblFileVersions Inner Join
  tblComputers On tblFileVersions.Computername = tblComputers.Computername
Where dbo.tblFileVersions.Found = 1 And dbo.tblFileVersions.FilePathfull Like
  '%ofcdog.exe'

[Hemoco]

Could you post the result about the file scanning part.
It's in table "tblfileversions"

You query should contain:
"Where found=1 and filepathfull like '%trendmicro.exe'"

(change trendmicro.exe to the file you scanned)

[tellis]

Here is the query I am using
***************
SELECT
tblFileVersions.Found,
tblFileVersions.FilePathfull,
tblComputers.Computername
FROM
tblFileVersions,
tblComputers
WHERE
dbo.tblFileVersions.Found = '1' AND
dbo.tblFileVersions.FilePathfull = 'C:\Program Files\Trend Micro\OfficeScan Client\ofcdog.exe'
***************

The query results in report builder are correct and list 92 computers but the lansweeper dashboard is report +2200 items found??

Also, I really do not want to use "C:\Program Files" in the query...what are my alternatives??

[tellis]

got the scanning file part but not sure about the report builder part.
I tried to look at the scripts for No F-Secure Installed and AVG Installed reports but both of those were corrupt out of the box (error=Invalid Token 'COLLATE' at position 595 of Line 1).

1) How do fix the No F-Secure and AVG Installed reports
2) How do I add my custom report (i.e. what table is the custom scan result stored in for instance)

[Hemoco]

First you will need to include the file you want scanned in the custom file scanning.
Then you will need to create a new report with the report builder and add it to your dash board.