selectNetBiosName 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.IPAddress0fromv_CH_ClientSummaryinner join v_R_System as sy on sy.ResourceID=MachineIDjoin dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on sy.ResourceID = NAC.ResourceIDwheresy.Operating_System_Name_and0 like '%workstation%'
and NAC.IPaddress0 is Not Null