Solved

WMI Filter to exclude an application

Posted on 2009-04-14
3
679 Views
Last Modified: 2012-05-06
I want to install the PowerPoint Viewer on any machine without an instance of PowerPoint installed.  My filter code is this -

SELECT * FROM Win32_Product
WHERE Name <> 'Microsoft Office PowerPoint%'

Although it installed on a test machine with PowerPoint 2007.  Do you know what the error in my syntax is?
0
Comment
Question by:rosederekj
  • 2
3 Comments
 
LVL 70

Accepted Solution

by:
Chris Dent earned 500 total points
ID: 24136437

You should be able to capture it with:

SELECT * FROM Win32_Product WHERE NOT Name LIKE 'Microsoft Office PowerPoint%'

It's just you can't use <> or = along with wildcards (% and _), only for explicit values, LIKE has to be used and if negation of that condition is needed NOT must appear before the condition.

Chris
0
 

Author Comment

by:rosederekj
ID: 24137061
Thanks, much appreciated, that worked perfectly.
0
 

Author Closing Comment

by:rosederekj
ID: 31569825
Perfect!
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question