Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Untag as favorite
Report version of Microsoft Office...
Jcb1974
#1 Posted : Tuesday, November 01, 2011 7:49:42 PM
Rank: Freeware user

Groups: Member
Posts: 2
Location: Weston, WV
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
Lansweeper
#2 Posted : Wednesday, November 02, 2011 11:28:25 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,378
Please use the following report:

Quote:
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
Users browsing this topic
Guest
Untag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba