Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

WQL query on WMIC command line

Posted on 2007-04-10
4
Medium Priority
?
3,921 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 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...
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
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 …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

670 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