When was a Software Update applied (SMS 2003)

select
    CS.Name0,
    PSE.title0,
    PSE.TimeApplied0
from
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_GS_PATCHSTATEEX PSE on CS.ResourceID = PSE.ResourceID

Leave a Reply

Your email address will not be published. Required fields are marked *