SMSUG.ca

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

Garth Jones

ARP for Collection SMS000ES

SELECT
    CS.Name0,
    CSUM.TopConsoleUser0,
    ARP.DisplayName0,
    ARP.Publisher0,
    ARP.Version0
FROM
    dbo.v_GS_ADD_REMOVE_PROGRAMS ARP,
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP CSUM,
    dbo._RES_COLL_SMS000ES ES
WHERE
    CS.ResourceID = ARP.ResourceID
    AND CS.ResourceID = CSUM.ResourceID
    AND CS.ResourceID = ES.MachineID

Published Dec 10 2008, 08:32 AM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

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