Computer without Microsoft 365 Installed

[tjkalb]

I tried a program from another post for software not installed on a computer, and it's not working. I want a list of all computers without Microsoft 365 installed. Help please!

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
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 365') And tblAssetCustom.State =
1
Order By tblAssets.Domain,
tblAssets.AssetName

[tjkalb]

Thanks! I did try with different wildcard - *. Why can't every program use the same wildcard?? lol

[RCorbeil]

Take a look at the query that's pulling the list of AssetID values where the software is found:

Select Top 1000000
  tblSoftware.AssetID
From tblSoftware
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Microsoft 365'

Since you're not using any wildcards, you're pulling a list of AssetID values where the software name exactly matches "Microsoft 365". From a look at my own inventory, I'll bet what you mean is to pull a list where the software name starts with "Microsoft 365",

Where tblSoftwareUni.softwareName Like 'Microsoft 365%'

or if you want to cover all bases and assume Microsoft may insert something before that some day, anything where the software name contains "Microsoft 365"

Where tblSoftwareUni.softwareName Like '%Microsoft 365%'