All IP's Assigned to Nodes

Adarsh12

Does any one has any idea on how to get 

All IP's Assigned to Nodes

Select nodesdata.Caption AS 'Device Name', NodeIPAddresses.IPAddress

From nodesdata

Join NodeIPAddresses

ON nodesdata.NodeID = NodeIPAddresses.NodeID

Where nodesdata.UnManaged = '0'

Above Query does not give additional ip's assigned to esxi's

KMSigma.SWI

Please stop manually joining things - use the navigation properties whenever possible.

SELECT [Node].Caption AS [Device Name]
     , [Node].NodeIPAddresses.Interface.Caption AS [Interface Name]
     , [Node].NodeIPAddresses.IPAddress AS [IP Address]
     , [Node].NodeIPAddresses.IPAddressType AS [IP Type]
FROM Orion.Nodes AS [Node]
ORDER BY [Node].Caption
       , [Node].NodeIPAddresses.IPAddressType
       , [Node].NodeIPAddresses.IPAddress