Workstation without antivirus - but without a special assetgroup

[Jokey]

Hello,

I've created an report that show me all of our workstations that have no Sophos anti-Virus installed.
But we have also a lot of ThinClients which have no Sophos installed. I don't want to see them in my report. All of the ThinClients are in the assetgroup "ThinClients". Is it possible to show me all computers that have the Sophos Anti-Virus installed but is not in the assetgroup "ThinClients"?

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 tblAssets On tblAssets.AssetID =
      tblSoftware.AssetID Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
      tblSoftware.softID
  Where tblSoftwareUni.softwareName = 'Sophos Anti-Virus') And
  tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName

[Hemoco · Accepted solution]

Please try this:
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 tblAssets On tblAssets.AssetID =
tblSoftware.AssetID Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName = 'Sophos Anti-Virus') And
tblAssets.AssetID Not In (Select tblAssets.AssetID
From tblAssets Inner Join tblAssetGroupLink On tblAssets.AssetID =
tblAssetGroupLink.AssetID Inner Join tblAssetGroups
On tblAssetGroups.AssetGroupID = tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'ThinClients')) And
tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName