Select DISTINCT
    sys.Netbios_Name0,
    fcm.SiteCode,
    sys.User_Domain0,
    sys.User_Name0,
    sys.Operating_System_Name_and0,
    arp.DisplayName0,
    ru.Full_user_Name0
FROM
    dbo.v_R_System sys
    JOIN dbo.v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
    JOIN dbo.v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
    join dbo.v_R_User ru on sys.User_Domain0 = ru.Windows_NT_Domain0 and sys.User_Name0 = ru.user_name0
WHERE
    DisplayName0 = @displayname
    and fcm.CollectionID=@CollID