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