Solved

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

Posted on 2011-09-18
11
3,144 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

856 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