Getting last windows update

[melmar]

Hi All,

Hoping someone can advise on the below.

I got the following query from another site and it works fine, except it gives the first update installed on my collections. I'm looking for the latest update installed and not the first.

 

Can any one advise please. All I want to do is get the last update that was applied on all my remote computers.

 

Thanks a mil.

 

SELECT
vWorkstationStatus.Name AS 'Computer name',
vWorkstationStatus.UserName AS 'User name',
v_GS_COMPUTER_SYSTEM.Manufacturer0 AS 'Manufacturer',
v_GS_COMPUTER_SYSTEM.Model0 AS 'Model',
v_GS_PC_BIOS.SerialNumber0 AS 'Serialnumber', CONVERT(varchar(20),
v_GS_OPERATING_SYSTEM.LastBootUpTime0, 100) AS 'Last Boot',
v_GS_OPERATING_SYSTEM.Caption0,
v_GS_OPERATING_SYSTEM.InstallDate0 AS 'Installation date'
FROM
vWorkstationStatus INNER JOIN
v_GS_PC_BIOS ON vWorkstationStatus.ResourceID = v_GS_PC_BIOS.ResourceID INNER JOIN
v_GS_OPERATING_SYSTEM ON vWorkstationStatus.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID INNER JOIN
v_GS_COMPUTER_SYSTEM ON v_GS_PC_BIOS.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID
WHERE
(vWorkstationStatus.OperatingSystem not like N'%server %')
Order by 'Computer name', Caption0 ASC;

 

 

[GarthMJ]

This query will in no way, shape or form, show you when the last SU was installed. For that matter, when the last SU was applied is completely useless info. Why? Because what happen when 1st SU fails but the 2nd SU is successful. You will have a false believe that you server it update.

Instead you should look at what SU are outstand for that server. This query will get you started. http://sccmug.ca/2009/02/25/patch-compliance-progression-report/