Report help

[rberg]

Need some help with this report I have currently, It is searching for machines without "Websense Endpoint". The problem I have is I am trying to only show Windows 7 x86 and x64 and Windows XP x86 and x64 machines. Anyone help me here?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tsysOS.Image As icon
From tblAssets
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
Where dbo.tblsoftwareuni.softwareName Like 'Websense Endpoint') And
tblAssetCustom.State = 1
Order By tblAssets.AssetName

[Hemoco · Accepted solution]

Please use the report below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tsysOS.Image As icon
From tblAssets
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
Where tblSoftwareUni.softwareName Like 'Websense Endpoint') And
tsysOS.OSname = 'win xp' And tblAssetCustom.State = 1) Or
(tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Websense Endpoint') And
tsysOS.OSname = 'win 7' And tblAssetCustom.State = 1)
Order By tblAssets.AssetName