Report version of Microsoft Office...

[Jcb1974]

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

[Hemoco · Accepted solution]

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]

How would this query change in version 5?

[Hemoco]

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