Solved

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

Posted on 2011-09-18
11
3,175 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
[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
  • 4
  • 3
11 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 500 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
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
The viewer will learn how to count occurrences of each item in an array.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

733 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