What do you expect us to do with that? The only thing I can offer is to format the code, but not much more.
select distinct
S.Netbios_Name0 as 'Computer Name',
N.IPAddress0 as 'IP Address',
S.User_Name0 as 'User Name',
U.Full_User_Name0 as 'Full User Name',
S.AD_Site_Name0 as 'Site'
from v_R_System S
join v_RA_System_IPAddresses I on I.ResourceID = S.ResourceId
join v_R_User U on U.User_Name0 = S.User_Name0
join v_GS_NETWORK_ADAPTER_CONFIGURATION N on N.ResourceID = I.ResourceID
left join v_FullCollectionMembership M on M.resourceid = N.ResourceID
join v_Collection C on C.CollectionID = M.CollectionID
where (M.CollectionID = @collid )
AND N.IPAddress0 NOT LIKE 'fe%'
AND N.IPAddress0 NOT LIKE '%::%'
AND N.IPAddress0 NOT LIKE '169%'
group by
S.Netbios_Name0,
N.IPAddress0,
S.User_Name0,
U.Full_User_Name0,
S.AD_Site_Name0
order by S.Netbios_Name0
The only thing that seems to be an issue, is that the LEFT JOIN is being converted to an INNER JOIN by your WHERE clause. However, that's your only filter, so there's no reason to make it an (LEFT) OUTER JOIN.