Solved

WQL query on WMIC command line

Posted on 2007-04-10
4
3,629 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DNS Settings for Domain controllers 22 111
Export a GPO and import a GPO 3 44
ACTIVE DIRECTORY 18 48
Admin account lockout 10 39
In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
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…

770 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