cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tjkalb
Engaged Sweeper II
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
2 REPLIES 2
tjkalb
Engaged Sweeper II
Thanks! I did try with different wildcard - *. Why can't every program use the same wildcard?? lol
RCorbeil
Honored Sweeper II
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%'

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now