What would be the procedure to scan for SAV client and def date. i see you have something like it for F-Secure and AVG, why not sav

Okay once i do that. What do i have to do for it to show up in the Web Console, i did a rescan but no following where i would see this information

You need to create a new query which can be used as a report and use the found information. (there is an example is the reports section of the forum)

I have this as a Custom report but it is showing all clients with 10.1.5 as needing updates, should it be anything under 10.1.5 show as needing updates.

I am new to the whole SQL Database

' This is a sample report that checks all computers if they have the latest version of SAV
' The file that we need to check : %programfiles%\Symantec AntiVirus\VPC32.exe

' Add the file that we need to scan to the tsysfiles table
' you can do the same from the GUI interface

INSERT INTO dbo.TsysFiles
(Searchfile, Enabled)
VALUES ('%programfiles%\Symantec AntiVirus\VPC32.exe', 1)


' Create the query to check for the latest version
' the latest version of our software is 10.1.5

CREATE VIEW dbo.web30repsav
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 '%vpc32%') AND (NOT (dbo.tblFileVersions.FileVersion LIKE '10.1.5'))
ORDER BY dbo.tblComputers.Computername

GO

'Add the view to the reports table

INSERT INTO [tsysreports] ([Reportquery],[Reporttitle]) VALUES ('web30repsav','SAV Update')

GO

Here is a screenshot of that file