Where tblAssets.AssetID Not In (Select tblAntivirus.AssetID
From tblAntivirus) And tblState.Statename = 'Active' And
tblDomainroles.Domainrolename In ('Stand-alone Workstation',
I know this is an older item but the first thing I see with this is that you state the machine is a server -- Windows 2016. The report is only including workstations -- > domainrole is "Stand-Alone Workstation" or "Member Workstation".