Check for specific Microsoft hotfixes?

[Dov]

Greetings,
Does anyone know if there's a way to script something which will show if a certain Microsoft hotfix is installed or not?
I would like to know if it's possible under the software reports to display the list of computers which don't have a certain hotfix (in this case, hotfix 958644 http://www.microsoft.com/technet/security/Bulletin/MS08-067.mspx), similar to how it shows a list of XP machines without SP3.
I hope it's possible, as not having this hotfix in place could prove to be a major headache ..

[Dov]

That worked, thank you!

[Hemoco]

(not checked for syntax errors)

select computername from tblcomputers where computername not in (select computername from tblQuickFixEngineering where ServicePackInEffect  = 'KB958644')  

[Dov]

Ok, here's the SQL script; I guess it's time to brush up on my SQL queries since I get a blank results page ..:

SELECT
tblComputers.Computername,
tblQuickFixEngineering.HotFixID,
tblQuickFixEngineering.Description
FROM
tblQuickFixEngineering
INNER JOIN tblComputers ON (tblQuickFixEngineering.Computername = tblComputers.Computername)
WHERE
tblQuickFixEngineering.ServicePackInEffect <> 'KB958644'

[Hemoco]

Check the table tblQuickFixEngineering, this should give you all needed information.
Field Servicepackineffect <> KB958644