→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ebrundige
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

2 REPLIES 2
Hemoco
Lansweeper Alumni
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
Honored Sweeper II
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