SMSUG.ca

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

Garth Jones

Server HF Status

select
    CS.Name0,
    PSE.Status0,
    count(PSE.Status0)
from
    dbo.v_GS_Computer_System cs left outer join dbo.v_GS_PATCHSTATEEX PSE on CS.ResourceID = PSE.ResourceID
    left outer join dbo.v_GS_SYSTEM S on CS.ResourceID = S.ResourceID
Where
    S.SystemRole0 = 'Server'
Group by
    CS.Name0,
    PSE.Status0

Published Jan 22 2009, 10:59 PM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

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