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