https://community.hpe.com/t5/server-management-insight/sql-query-for-rib-ip-address/m-p/3049875#M8885 There's a view in the Insight Database queries called view_DeviceAssociates. This should have everything you need.<BR /><BR />Taking things further, opening the view, shows that it calls data from the DeviceAssociations and Devices Tables. Fri, 15 Aug 2003 15:25:04 GMT James Kennedy_4 2003-08-15T15:25:04Z https://community.hpe.com/t5/server-management-insight/sql-query-for-rib-ip-address/m-p/3049874#M8884 Any one have a clue on the location in database where the ip address of the rib is kept? I'm hoping to be able to cross reference the server name to the rib address??<BR /><BR />Thanks<BR />Nick Fri, 15 Aug 2003 14:09:34 GMT https://community.hpe.com/t5/server-management-insight/sql-query-for-rib-ip-address/m-p/3049874#M8884 Nick Sullivan 2003-08-15T14:09:34Z https://community.hpe.com/t5/server-management-insight/sql-query-for-rib-ip-address/m-p/3049875#M8885 There's a view in the Insight Database queries called view_DeviceAssociates. This should have everything you need.<BR /><BR />Taking things further, opening the view, shows that it calls data from the DeviceAssociations and Devices Tables. Fri, 15 Aug 2003 15:25:04 GMT https://community.hpe.com/t5/server-management-insight/sql-query-for-rib-ip-address/m-p/3049875#M8885 James Kennedy_4 2003-08-15T15:25:04Z