Solved

WMI Filter to exclude an application

Posted on 2009-04-14
3
680 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

830 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