[gptalk] Re: WMI Filters

  • From: "Darren Mar-Elia" <darren@xxxxxxxxxx>
  • To: <gptalk@xxxxxxxxxxxxx>
  • Date: Fri, 26 Sep 2008 10:22:59 -0700

If you are trying to exclude machines that have Office 2007 already installed 
(or more specifically have Office 2003 installed), then something like this 
might work, though I’m not in front of a machine to test it:


SELECT * FROM Win32_Product WHERE Caption LIKE "%Microsoft Office%" AND Caption 
LIKE "%2003%"

That would likely evaluate to true only if Office 2003 were there. 

Also, keep in mind that for whatever reason, my experience with enumerating 
Win32_Product is that its very slow if you have a fair number of apps on a 
system. So, keep an eye on GP Processing time after implementing this as it 
could go to minutes.





From: gptalk-bounce@xxxxxxxxxxxxx [mailto:gptalk-bounce@xxxxxxxxxxxxx] On 
Behalf Of Frank
Sent: Friday, September 26, 2008 9:46 AM
To: gptalk@xxxxxxxxxxxxx
Subject: [gptalk] Re: WMI Filters


You want to prevent installation of Office 2007 onto workstations that have 
Office 2003 installed already?

My understanding of WMI filters (as applied to a GPO) is that if the query 
returns anything, then (you've got a "true" and) the condition is met, which 
makes it tricky to negate something like the presence of a product, as opposed 
to something simple like "has more than 512mb of RAM".  --If I'm wrong, please, 
pretty please shed some light here!!!  (I beg of you!) 

Another thing you could do is use/create an MST onto 2007 that adds an Install 
Condition making sure there's no other Office version installed before 
proceeding.  Otherwise perhaps basing your query around the Office 2003 Product 
code might help.


On Fri, Sep 26, 2008 at 12:16 PM, Thomas Marantz <TomMarantz@xxxxxxxxxxxxxxxx> 

I have an Office 2007/2003 environment.

I have deployed Office 2007 compatibility pack for Office 2003 workstations.

I've been trying to get a Filter to block installation on Office 2007 
workstations, here is what I have…


SELECT * FROM Win32_Product WHERE (Caption LIKE "Microsoft Office%2003%")


Other related posts: