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

Leave a Reply

Your email address will not be published. Required fields are marked *