Symantec AV and Dat version report

[jpv]

Hello,

I would like to generate report showing all Windows systems with the following:

1. Symantac Anti-virus agent installed and running
2. The version of the DAT file used by Symantec

Thank you in advance!

[Hemoco · Accepted solution]

1. If this is a service listed in services.msc, you can try the sample report below. Replace YourService with the name of the service.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblServicesUni.Caption,
tblServices.Started
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Where tblServicesUni.Caption = 'YourService' And tblServices.Started = 1
And tblAssetCustom.State = 1

2. The only way to detect this would be through a custom file or registry scan.

File scanning example: http://www.lansweeper.com/kb/19/report-based-on-file-information.html
Registry scanning example: http://www.lansweeper.com/kb/18/report-based-on-registry-keys.html