Select
sys.Netbios_Name0,
fcm.SiteCode,
sys.User_Domain0,
sys.User_Name0,
sys.Operating_System_Name_and0,
arp.DisplayName0,
ARP.InstallDate0
FROM
v_R_System sys
JOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE
DisplayName0 = @displayname
and fcm.CollectionID=@CollID