→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Jcb1974
Engaged Sweeper
I need to poll the network for a list of workstations that do NOT have Microsoft Office installed. (And tailor it later for others, Adobe Acrobat, for ex.) Or, a way to compare one list to another and arrive at my list of workstations w/o Office installed by a process of elimination. I looked through the forum and didn't see a thing. Can anyone help me?

Warmest regards,

Joel Bailey
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
For 5.0, use the query below.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress As IP,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Office%') And
tblAssets.Lastseen <> '' And tblAssets.Assettype = -1
Order By tblAssets.AssetUnique

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
For 5.0, use the query below.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress As IP,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Office%') And
tblAssets.Lastseen <> '' And tblAssets.Assettype = -1
Order By tblAssets.AssetUnique
MiJaMu
Engaged Sweeper
How would this query change in version 5?
Hemoco
Lansweeper Alumni
Please use the following report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblSoftware.ComputerName
From tblSoftware Where tblSoftware.softwareName Like '%Microsoft Office%')
Order By tblComputers.Computername

New to Lansweeper?

Try Lansweeper For Free

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

Try Now