Solved

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

Posted on 2011-09-18
11
3,263 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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

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…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

717 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