Adding IP address to Client Summary data

select 

	NetBiosName as "CAM NetBiosName", 

	LastPolicyRequest as "CAM LastPolicyRequest", 

	LastDDR as "CAM LastDDR", 

	sy.Operating_System_Name_and0 as "Operating System", 

	sy.Resource_Domain_OR_Workgr0 as "AD Domain",

	NAC.IPAddress0

from 

	v_CH_ClientSummary

	inner join v_R_System as sy on sy.ResourceID=MachineID 

	join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on sy.ResourceID = NAC.ResourceID

where 

	sy.Operating_System_Name_and0 like '%workstation%'

	and NAC.IPaddress0 is Not Null