[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

wrong date of installdate on the output of wmic /node:server01 QFE get HotFixID, InstalledBy, InstalledOn

Posted on 2011-09-18
11
Medium Priority
?
3,507 Views
Last Modified: 2013-11-08
Hi all,

i am trying to export a list of all the installed Windows security patches on Windows 2008 SP2 servers for log management purposes.
i am using this command:

wmic /node:server01 QFE get HotFixID, InstalledBy, InstalledOn
and i got the wrong installedOn date, here is what i get :
HotFixID                                InstalledBy                                      InstalledOn
{AC76BA86-7AD7-0000-2550-7A8C40000934}                                                   20100922
KB971513                                S-1-5-21-3825283475-4269483969-3991436212-20890  01cb11c60a8d798c
KB971512                                S-1-5-21-3825283475-4269483969-3991436212-20890  01cb11c60a917146
944036                                  S-1-5-21-2439542126-1473891312-3459812188-500    01cb0ce8a5f3c27d
KB960362                                S-1-5-21-3825283475-4269483969-3991436212-20890  01cb11c60a920d8a
KB2079403                               S-1-5-21-3825283475-4269483969-3991436212-6209   01cb701e6c8d90e1
KB2141007                               S-1-5-21-3825283475-4269483969-3991436212-6209   01cb701e6c8e0614
KB2158563                               S-1-5-21-3825283475-4269483969-3991436212-6209   01cb701e6c8ea258

what i need to know is:
the list of the installed patches sorted by installeddate/installedOn, but for some reasons the output of above command did not show the installeddate/installedOn correctly

do you know how to get the list with the correct installeddate/installedOn ?
do you know of any utility that we can do the same thing instead of the wmic command ?

there is one link about this :
http://social.technet.microsoft.com/Forums/en-US/winservergen/thread/90717cdc-001c-4d63-b059-4b444e5d9ee8/
but i dont want to use PowerShell cmdlet
thanks

0
Comment
Question by:gsawan
  • 4
  • 3
7 Comments
 

Author Comment

by:gsawan
ID: 36578063
hi admin
pls get someone to answer my question
thanks!
0
 
LVL 66

Accepted Solution

by:
johnb6767 earned 1500 total points
ID: 36578309
This is not exactly what you are looking for but I wanted to offer it.....

Puts it into a nice pretty HTML format....

wmic QFE get HotFixID, InstalledBy, InstalledOn /format:htable >C:\Temp\hotfixes.htm

Course it works as a local command, dont think you can use the ">export" with a remote node..... Might just have the syntax wrong...
0
 

Author Comment

by:gsawan
ID: 36578378
based on this one:
http://social.technet.microsoft.com/Forums/en-US/winserverManagement/thread/069a4389-4c55-41c9-98f8-8199e5766907/

"According to the research, when we use WMI class: Win32_QuickFixEngineering to query the InstalledOn property, the system will return an encoded Date String (HEX). "
i know the InstalledOn is shown in enconded Hex and we cant read this,
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 66

Expert Comment

by:johnb6767
ID: 36584896
Thats why I have been partial to the command I posted above...
0
 

Author Comment

by:gsawan
ID: 36584974
so, how do we fix the wrong date format ?
i think someone posted that we can use Power shell scrips, if you guy know the power shell script to do this, pls post it here
0
 
LVL 66

Expert Comment

by:johnb6767
ID: 36597138
Im sorry, I cannot help to get this in a better format....
0
 

Author Closing Comment

by:gsawan
ID: 37015704
thanks!
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
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…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
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…
Suggested Courses
Course of the Month17 days, 21 hours left to enroll

830 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