Code:
JOIN Inv_AeX_AC_TCPIP z
ON z.[IP Address] = i._ResourceGuid
can't join on that, an IP address wont match to an object GUID
try
on z._ResourceGuid = i._ResourceGuid
If that air lookup doesnt work, I'll throw it into SSMS and write it up for you.