Solved

WQL query on WMIC command line

Posted on 2007-04-10
4
3,577 Views
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!
JohnD
0
Comment
Question by:johndarby
  • 3
4 Comments
 
LVL 67

Expert Comment

by:sirbounty
ID: 18884554
Did you try using the single apostrophe?

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

Accepted Solution

by:
sirbounty earned 500 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...
0
 
LVL 1

Author Comment

by:johndarby
ID: 18884656
As ever, you are the font of useful information! Thank you!
JohnD
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 18884666
:^)
Glad I could help you again!  
Thanx for the grade.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Resolve DNS query failed errors for Exchange
This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now