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
