Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

WMI Filter to exclude an application

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
rosederekj
Asked:
rosederekj
  • 2
1 Solution
 
Chris DentPowerShell DeveloperCommented:

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
 
rosederekjAuthor Commented:
Thanks, much appreciated, that worked perfectly.
0
 
rosederekjAuthor Commented:
Perfect!
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now