SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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

Published Apr 16 2009, 07:30 AM by Garth
Filed under: , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems