I have a small subset of workstations that are vendor supplied using Windows 20 2016 LTSB. All workstations have Trend Micro installed, and appear fine in my trend management server, but in LanSweeper, I have a report to indicate workstations that are missing A/V software. My clause works like this:
Where tblAssets.AssetID Not In (Select tblAntivirus.AssetID
From tblAntivirus) And tblState.Statename = 'Active' And
tblDomainroles.Domainrolename In ('Stand-alone Workstation',
'Member Workstation')
These assetIDs do not populate in this table despite showing Antivirus on the summary page of the asset itself. Why won't these devices populate in this table like other devices do?