How to monitor TrendMicro Anti virus?

[udiburg]

Hi,

How can I configure the program to monitor if TrendMicro antivirus is installed?

Udi.

[Anonymous]

It's well documented, sorry I can't help you more than this.

[Anonymous]

Scan for the file PccNTMon.exe then this report will give you the computers where Trend is not installed:

SELECT     TOP (100) PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblFileVersions.Lastchanged
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
                      dbo.tblFileVersions ON dbo.tblComputers.Computername = dbo.tblFileVersions.Computername AND dbo.tblFileVersions.Found = 0
WHERE     (dbo.tblFileVersions.FilePathfull LIKE '%PccNTMon.exe') AND (dbo.tblComputersystem.Domainrole LIKE '1')
ORDER BY Computer

This report will exclude servers since I only use Trend on PC's

[udiburg]

BullGates wrote:
Scan for the file PccNTMon.exe then this report will give you the computers where Trend is not installed:

SELECT     TOP (100) PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblFileVersions.Lastchanged
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
                      dbo.tblFileVersions ON dbo.tblComputers.Computername = dbo.tblFileVersions.Computername AND dbo.tblFileVersions.Found = 0
WHERE     (dbo.tblFileVersions.FilePathfull LIKE '%PccNTMon.exe') AND (dbo.tblComputersystem.Domainrole LIKE '1')
ORDER BY Computer

This report will exclude servers since I only use Trend on PC's

Ok,
But how do I create a report from it in the freeware version?

[udiburg]

BullGates wrote:
Scan for the file PccNTMon.exe then this report will give you the computers where Trend is not installed:

SELECT     TOP (100) PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblFileVersions.Lastchanged
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
                      dbo.tblFileVersions ON dbo.tblComputers.Computername = dbo.tblFileVersions.Computername AND dbo.tblFileVersions.Found = 0
WHERE     (dbo.tblFileVersions.FilePathfull LIKE '%PccNTMon.exe') AND (dbo.tblComputersystem.Domainrole LIKE '1')
ORDER BY Computer

This report will exclude servers since I only use Trend on PC's

Thanks,

I will check and reply.

[Hemoco]

You can do it in the free version as well if you manually edit the sql commands and tables.

[udiburg]

Lansweeper wrote:
You can do it in the free version as well if you manually edit the sql commands and tables.

Wow! Sounds complicated. I have SQL express, can I do it on it as well?

[Hemoco]

If it's in the software list you can create a report for it.
If it's not in the software list you need to specify the filename to scan for and create a report based on this.

[udiburg]

Lansweeper wrote:
If it's in the software list you can create a report for it.
If it's not in the software list you need to specify the filename to scan for and create a report based on this.

As I read in the documentation, creating new reports is available only in the Premium version. Isn't it?