Solved

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

Posted on 2011-09-18
11
3,048 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
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
 
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

Join & Write a Comment

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…
A procedure for exporting installed hotfix details of remote computers using powershell
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 to another domain controller. Log onto the new domain controller with a user account t…
The viewer will learn how to dynamically set the form action using jQuery.

747 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

12 Experts available now in Live!

Get 1:1 Help Now