Orion Nodes, Interface and NodeIPAddress JOIN query

syeal01

Greetings, I need to get IP Addresses of Interfaces (which are in NodeIPAddress basically but couple more info from Nodes and NPM Interfaces also.
Came up with this query but for every Interface, the IPAddress table is repeated. So instead of 19 rows, I get 437 rows.
Can someone with knowledge help please.

SELECT DISTINCT
   [Nodes].Caption,
   [Nodes].IP_Address,
   [Interfaces].InterfaceAlias,
   [Interfaces].TypeDescription,
   [Addresses].IPAddress,
   [Addresses].SubnetMask
FROM Orion.Nodes AS [Nodes]
INNER JOIN Orion.NPM.Interfaces AS [Interfaces]
   ON [Nodes].NodeID = [Interfaces].NodeID
INNER JOIN Orion.NodeIPAddresses AS [Addresses]
   ON [Nodes].NodeID = [Addresses].NodeID
WHERE IP_Address = '1.2.3.4'
ORDER BY InterfaceName

yaquaholic

Hi,

I've cleaned it up a little, using the internal SWQL table connections.

And I think it works

SELECT 
   DISTINCT([Nodes].Caption),
   [Nodes].IP_Address,
   [Nodes].Interfaces.InterfaceAlias,
   [Nodes].Interfaces.TypeDescription,
   [Nodes].NodeIPAddresses.IPAddress,
   [Nodes].NodeIPAddresses.SubnetMask   
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].IP_Address LIKE '1.1.1.1'
ORDER BY [Nodes].Interfaces.InterfaceAlias

I hope it is of some help,

Rich