SCCM - Collection Query (Computers with IP address and last logged on username from a given collection)

select A.Name0,c.IPAddress0 as "IP ADDRESS",E.UserName0 as "Lastlogged user"
from v_R_System A inner join
v_FullCollectionMembership B on
A.ResourceID=B.ResourceID
Inner join v_GS_NETWORK_ADAPTER_CONFIGUR  C ON
A.ResourceID=C.ResourceID
Inner join v_GS_COMPUTER_SYSTEM E ON A.ResourceID=E.ResourceID
where CollectionID=@COLLID and C.IPEnabled0=’1′ and c.ipaddress0 !=’0.0.0.0′
group by A.Name0,c.IPAddress0 ,E.UserName0