Hi.
You can get this list from DB using following query:
I've also made a simple report for that, it's available in svn: http://svn.netxms.org/public/netxms/trunk/reports/IP%20Inventory.jrxml
To run it you need to setup your netxms server first:
1) download https://netxms.org/report-generator.jar and put it into server's DataDirectory (default values are c:\NetXMS\var on Windows and $prefix/share/netxms/ on UNIX)
2) add following parameters to netxmsd.conf:
After that you could import report definition in management console by right click on "Reports" in the object browser and selecting "New Report"
You can get this list from DB using following query:
Code Select
SELECT
interfaces.ip_addr AS interfaces_ip_addr,
interfaces.ip_netmask AS interfaces_ip_netmask,
object_properties.name AS object_properties_name,
interfaces.node_id AS interfaces_node_id
FROM
object_properties
INNER JOIN
interfaces
ON
object_properties.object_id = interfaces.node_id
ORDER BY
interfaces_node_id, interfaces_ip_addrI've also made a simple report for that, it's available in svn: http://svn.netxms.org/public/netxms/trunk/reports/IP%20Inventory.jrxml
To run it you need to setup your netxms server first:
1) download https://netxms.org/report-generator.jar and put it into server's DataDirectory (default values are c:\NetXMS\var on Windows and $prefix/share/netxms/ on UNIX)
2) add following parameters to netxmsd.conf:
Code Select
JavaPath=/usr/bin/java
JDBCDriver=org.postgresql.Driver
JDBCUrl=jdbc:postgresql://localhost/netxmsAfter that you could import report definition in management console by right click on "Reports" in the object browser and selecting "New Report"