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;