SELECT
SYS.Netbios_Name0,
SYS.User_Domain0,
SYS.User_Name0,
ASSG.SMS_Installed_Sites0,
SYS.Client_Version0,
Coll.Name
FROM
V_Collection COLL,
v_R_System SYS
left outer join dbo.v_FullCollectionMembership FCM on SYS.ResourceID=FCM.ResourceID
JOIN v_RA_System_SMSInstalledSites as ASSG on SYS.ResourceID=ASSG.ResourceID
WHERE
COLL.Name LIKE @variable
and Coll.CollectionID = FCM.CollectionID
Order by
SYS.Netbios_Name0