NCM.EntityPhysical with ip address

avivi

Hi

On swql with NCM.EntityPhysical there is no ipaddres or name of the swich from where i can do join to add them ? 

yaquaholic

Hi Avivi,

Try something like this

SELECT TOP 10 EP.EntityID, EP.EntityName, EP.EntityDescription, N.NodeCaption, N.AgentIP
FROM NCM.EntityPhysical AS EP
LEFT JOIN NCM.Nodes AS N
ON N.NodeID = EP.NodeID

Rich