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