I am trying to simply add a report to show the computers that do NOT have Trend Micro OfficeScan installed.

I have added the file to the scan options through the gui, and now am trying to add the report so it will show up in the web console.

I have been looking for an example of a report like this and have not found one.

Thanks,

TCU

I successfully created the scanned file, and the report.

However, in the web console the report shows up but I do not believe it is giving accurate results. I am pretty sure that there are a couple of machines that do not have Trend Micro Officescan on them.

Can you review this and see if I am accurate?

' This is a sample report that checks all computers if they have the latest version of OfficeScan Client
' The file that we need to check : %programfiles%\Trend Micro\OfficeScan Client\PccNTMon.exe

' Create the query to check for the installed application
' version is not relevant

CREATE VIEW dbo.web30repnotinstalledofficescan
AS
SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblFileVersions.FileVersion, dbo.tblFileVersions.FileDescription, dbo.tblFileVersions.Filesize, dbo.tblFileVersions.Lastchanged
FROM dbo.tblComputers INNER 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 '%programfiles%\Trend Micro\OfficeScan Client\PccNTMon.exe')
ORDER BY dbo.tblComputers.Computername

GO

'Add the view to the reports table

INSERT INTO [tsysreports] ([Reportquery],[Reporttitle]) VALUES ('web30repnotinstalledofficescan','Not running OfficeScan')

GO

Thanks,

TCU

Since you are a premium user it would be easier to just copy/paste the sql code in the query builder



You also need to start the GUI management console and add "'%programfiles%\Trend Micro\OfficeScan Client\PccNTMon.exe" to the list of scanned files.