WQL query on WMIC command line

Posted on 2007-04-10
Medium Priority
Last Modified: 2008-05-31
How do I enter a WQL query on the WMIC command line? An example query I'd lke to run is below...

"SELECT * FROM Win32_QuickFixEngineering WHERE Name="KB123456"

Thank you!
Question by:John Darby
  • 3
LVL 67

Expert Comment

ID: 18884554
Did you try using the single apostrophe?

SELECT * FROM Win32_QuickFixEngineering WHERE Name='KB123456'
LVL 67

Accepted Solution

sirbounty earned 2000 total points
ID: 18884614
Oh, I misread this - you're using the command line wmic...
Use something like this:

wmic QFE get CSName, Description, FixComments, HotFixID, InstalledBy, InstalledOn, Name |find /i "123456"

Otherwise, drop the output into a csv file and sort it in excel.

Could get more specific output using a vbs, if you're interested...

Author Comment

by:John Darby
ID: 18884656
As ever, you are the font of useful information! Thank you!
LVL 67

Expert Comment

ID: 18884666
Glad I could help you again!  
Thanx for the grade.

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
A bad practice commonly found during an account life cycle is to set its password to an initial, insecure password. The Password Reset Tool was developed to make the password reset process easier and more secure.
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…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

624 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