→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
David_Elliott
Engaged Sweeper II
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'
2 REPLIES 2
David_Elliott
Engaged Sweeper II
that did the trick. thank you.
Hemoco
Lansweeper Alumni
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