i tried generating report on interfaces using both ip address and node name as fields but got no activity to report
If you want to use a SWQL query try this
SELECT [Node].Caption AS [Caption] , [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