Report with two conditionals

[David_Elliott]

We're about to start a migration to Office 365. I've created my report to list all computers without it installed and included the Windows criteria. However, this also includes my Windows servers. How can I exclude them?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName As AssetName1,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where
tblSoftwareUni.softwareName Like 'Microsoft Office 365 ProPlus - en-us%')
And tsysAssetTypes.AssetTypename = 'Windows'

[David_Elliott]

that did the trick. thank you.

[Hemoco]

Please use the following query:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName As AssetName1,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblComputersystem.Domainrole
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where
tblSoftwareUni.softwareName Like 'Microsoft Office 365 ProPlus - en-us%')
And tsysAssetTypes.AssetTypename = 'Windows' And
tblComputersystem.Domainrole < 2