Anit-virus software report

[ebrundige]

I would like to get this report to pick up the Trend Micro anti-virus software we use. How do I go about editing it so it reports properly? This is the "Default" Workstation: All workstations without Anti-virus software report...Thanks



Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID Inner Join tsysantivirus On tblSoftwareUni.softwareName
Like tsysantivirus.Software) And tblComputersystem.Domainrole < 2 And
tblAssetCustom.State = 1
Order By tblAssets.AssetName

[Hemoco · Accepted solution]

Please ensure that:
- The anti-virus software package is listed in the Software tab of your computer webpages.
- The anti-virus software package is included in the anti-virus list found under Configuration/Software/Anti-Virus. If it isn't, you can manually add it.

Anti-virus reports work as follows:
- Lansweeper looks at an asset's software records, the records listed in the Software tab.
- Lansweeper compares these records against the anti-virus software list found under Configuration/Software/Anti-Virus.
- If a software package installed on an asset is included in Configuration/Software/Anti-Virus, that asset is deemed to have anti-virus software installed.

[RCorbeil]

ebrundige wrote:
I would like to get this report to pick up the Trend Micro anti-virus software we use.

Something like this?

Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblAssets.Description,
  tblAssets.Lastseen,
  tsysOS.Image As icon,
  tblSoftwareUni.SoftwarePublisher,
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion
From
  tblAssets
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Inner Join tsysantivirus On tblSoftwareUni.softwareName Like tsysantivirus.Software
Order By
  tblAssets.AssetName