How to check what kind of hotfix are installed in a PC

To check what kind hotfix has been installed, we could use a tool Pstools available from Microsoft.

http://technet.microsoft.com/en-us/sysinternals/bb897550

The command line is very straightforward, you simply do that by

psinfo -h

And then you will see something like this

P:\Desktop\pstools>psinfo -h
PsInfo v1.75 - Local and remote system information viewer
Copyright (C) 2001-2007 Mark Russinovich
Sysinternals - www.sysinternals.com
System information for \\x12354
Uptime:                    0 days 21 hours 16 minutes 53 seconds
Kernel version:            Microsoft Windows XP, Multiprocessor Free
Product type:              Professional
Product version:           5.1
Service pack:              3
Kernel build number:       2600
Registered organization:   Fei
Registered owner:          Fei User
Install date:              8/6/2010, 8:05:42 PM
Activation status:         Error reading status
IE version:                7.0000
System root:               C:\WINDOWS
Processors:                2
Processor speed:           2.7 GHz
Processor type:            Intel(R) Core(TM)2 Duo CPU     E7400  @
Physical memory:           3292 MB
Video driver:              Intel(R) 4 Series Internal Chipset
Installed     HotFix
10/6/2010     Microsoft Internationalized Domain Names Mitigation APIs
10/6/2010     Microsoft National Language Support Downlevel APIs
11/11/2010    Security Update for Windows Media Player (KB2378111)
8/7/2010      Security Update for Windows Media Player (KB954155)
8/7/2010      Security Update for Windows Media Player (KB968816)
8/7/2010      Security Update for Windows Media Player (KB973540)
1/10/2010     Security Update for Windows Media Player (KB975558)
26/7/2010     Security Update for Windows Media Player (KB978695)
10/6/2010     Security Update for Windows Media Player 10 (KB917734)
8/7/2010      Security Update for Windows XP (KB941569)
8/7/2010      Security Update for Windows Internet Explorer 7 (KB974455)
8/6/2010      Windows XP Service Pack 3
4/9/2010      Security Update for Windows XP (KB2079403)
4/9/2010      Security Update for Windows XP (KB2115168)
1/10/2010     Security Update for Windows XP (KB2121546)
4/9/2010      Security Update for Windows XP (KB2160329)
29/7/2010     Security Update for Windows XP (KB2229593)
1/10/2010     Security Update for Windows XP (KB2259922)
11/11/2010    Security Update for Windows XP (KB2279986)
12/8/2010     Security Update for Windows XP (KB2286198)
......

If you are going to feed this information to an automation script so that you can consolidate all inforamtion by yourself, you can use the script like this.

del checkhotfix.txt /q
del 0123894985.txt /q
psinfo -h > 0123894985.txt
for /f "skip=18 tokens=1*" %%i in (0123894985.txt) do @echo %%i %%j >> checkhotfix.txt

This script will skip the first 18 lines of the information so you can easily import them into an access or SQL database for further analysis.