NetXMS Support Forum

My bad, it should be https://netxms.org/report-generator.jar (or you can build it from svn: https://svn.netxms.org/public/netxms/trunk/src/java/report-generator)

I don't have MSSQL available right not to test, but connection string should be like jdbc:microsoft:sqlserver://server_name:port/dbname. Port (including colon) is optional, default value is 1433.

Also set JDBCDriver to "com.microsoft.sqlserver.jdbc.SQLServerDriver".

Hi.

You can get this list from DB using following query:
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_addr

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:JavaPath=/usr/bin/java
JDBCDriver=org.postgresql.Driver
JDBCUrl=jdbc:postgresql://localhost/netxms

After that you could import report definition in management console by right click on "Reports" in the object browser and selecting "New Report"

Sorry for delayed answer; I've just fixed RSS feed.

Quote from: tops on July 08, 2011, 11:59:13 AM
Hi.
Maybe a dumb question, but where do i find DCI properties dialog?

Right click on an object in object browser → Data Collection → double click on DCI

Right now "CreateCrashDumps" is Windows only parameter.
You can run server under gdb:gdb /path/to/netxmsd
Then in GDB prompt:(gdb) run -c /path/to/netxmsd.conf -D3

When it crash, do thread apply all bt

You can use msmtp (http://msmtp.sourceforge.net/) instead of built-in smtp sender.

1) Control Panel -> Server Configuraration:
set "SMTPServer" to yout SMTP server IP

2) Control Panel -> Actions:
Right click -> New.
Set options as shown on attached image (email_action.png)

3) Control Panel -> Event Processing Policy:
Find rule for SYS_NODE_DOWN event, right click on "Action" field and add action you've created in previous step.
EPP should be like shown on attached image (epp.png)

Какое количество открытых сокетов, когда перестает работать icmp в NetXMS?

for f in /proc/net/{tcp,udp,raw}; do wc -l $f ; done

Нет, не в текущей версии.

Thank you for backtrace, I've found problem.

Fix will be released in upcoming 1.0.8, meanwhile you can apply attached patch.

Best regards,
Alex.

Try to use double backslashes in command, single backslash is an escape character.c:\\test.bat

Thank you for report.

There are two options:

1) use odbcquery subagent (it works with unixODBC too):
You need to configure desired queries along with pool interval in agent config, they will be executed automatically by agent. Subagent provide couple of DCIs to get status of these configured queries (ODBC.QueryResult, ODBC.QueryStatus, ODBC.QueryStatusText)

2) add ExternalParemeter to agent's config, like this:ExternalParameter = SQL.CountEventLog:echo 'SELECT count(*) from event_log' | psql -tA netxms_db

Hello.

We have discovered that database upgrade from 1.0.5 to 1.0.6 can be slow in some cases, especially with large amount of data collected (one of our customers reported 1.5 hours).

Work is in progress on this issue and fix will be released later today.

We suggest you to stick to 1.0.5 until patch is released.

It's hard to tell, since it depends not only on number of nodes, but also number of DCIs on each node,  how often you check for new data, etc.

I've seen installation of NetXMS running on P3/750 with 2gb of RAM monitoring 200 nodes, with approximately 20 DCIs per node and collection interval of 1 minute.
Database (MySQL in that case) was running on the same server.