What do you expect us to do with that? The only thing I can offer is to format the code, but not much more.
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%'
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.
How to post data/code on a forum to get the best help: Option 1 / Option 2
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?