Antivirus Install Count Report Issues

[anpatterson03]

I have modified the software installed report to get a count of all our PCs that have Trend Micro Security Agent installed and no matter how I modify the parameters I have 16 systems that won't show up on the report. I have gone to the individual machines to make sure that Lansweeper is pulling that the software is install and it is and it even shows under the Antivirus section. Any help would be appreciated. Below is the SQL code from the report.

Select Distinct Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tblAssetCustom.Department,
tblAssetCustom.Branchoffice,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Username,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblState.Statename,
tblAssets.Domain,
tblAntivirus.DisplayName
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join tblState On tblAssetCustom.State = tblState.State
Inner Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID
Where tblSoftwareUni.softwareName Like 'trend micro worry-free%' And
tblAssetCustom.Location != 'department name' And tblAssets.Domain =
'company'
Order By tblAssetCustom.Department,
tblAssetCustom.Branchoffice,
tblAssets.AssetName

[anpatterson03]

I have, but that report is cumbersome due to showing both software info and wmi info. I have looked at the report though to see if the missing computers appear there and they do, including with the software install.

[Esben_D]

There is a built-in report for finding anti-virus software installed on your machines, have you tried that?

https://www.lansweeper.com/forum/yaf_postst10211_Windows--All-workstations-without-antivirus-software--Built-in.aspx#post38676