NetXMS Forum

I think this is what you are looking for. If not, it should get you started. I did not find a " time resolved" field, only the last time the alarm was changed. Which I am assuming, if it was resolved or terminated, that would be the last time it was changed. I added in the source object name, as I thought that would be useful. select object_properties.name as 'Node Name', alarms.alarm_id as 'Alarm ID', alarms.message as 'Message', DATEADD(S,alarms.creation_time, '1970-01-01') as 'Date Created',DATEADD(S,alarms.last_change_time, '1970-01-01') as 'Date Last Changed', CONVERT(varchar, (alarms.last_change_time-alarms.creation_time) / 86400) + ':' + CONVERT(varchar, DATEADD(s, (alarms.last_change_time-alarms.creation_time), 0), 108) as 'Age DD:HH:MM:SS' from alarms inner join object_properties on object_properties.object_id=alarms.source_object_id where alarms.alarm_state > 1 order by alarms.last_change_time desc

Create a cluster with two nodes, configure DCIs on the cluster itself - it will be propagated to both nodes

Hi, most likely problem caused by trusted node check. You should either add current node (where script is being executed) to list of trusted nodes on node sw, or disable trusted nodes check completely by setting server configuration parameter CheckTrustedNodes to 0 and restart server. Best regards, Victor

I think guide is wrong. Don't have access to oracle right now so can't check, but it should be like this (if environment is set correctly and "sqlplus Netxms/mpsdev@MPSDEV1" connects successfully): Database = id=mpsdev1;driver=oracle.ddr;server=MPSDEV1;login=Netxms;Password=mpsdev or you can use instant client connection string without tnsnames: Database = id=mpsdev1;driver=oracle.ddr;server=//lltcdevoda1-scan:1521/mpsdev1;login=Netxms;Password=mpsdev or you can even use full connection string there (haven't tried that, but should work as well): Database = id=mpsdev1;driver=oracle.ddr;server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lltcdevoda1-scan)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mpsdev1)));login=Netxms;Password=mpsdev

I'm using 2.2.10 version. What suppose that show threshol option should do?

Hi, currently not. Best regards, Victor

Hi Team In Dashboard, line chart, while setting Y-Axis Range (using Automatic) is it possible to restrict lowever value to "0" If I choose Manual option it seems I need to give "From" and "To" value, in our case we do not know what would be upper value, so I prefered to choose Automatic mode, however, I want to restrict the lowever value to "0", because I know we never get negative lowever value. Is there any option(setting available) which will enable me to restrict the lowever value to "0" in Automatic mode. Regards Naga

You missing some of the dependencies. You can either build them yourself, or wait a bit – I'll push them to maven central.

Hello Team I have to execute by explicity spcifying the path in the command after modifying the "nxreporting.xml" to have datasource information java -cp /apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/lib/\*.jar:/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/conf:/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/nxreporting-2.0-M2.jar com.radensolutions.reporting.Launcher Now I am getting database connection error: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection I have attached full output of above command execution The content of update "nxreporting.xml", please let me know whether this xml content is correct or not <config>   <workspace>/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace</workspace>     <netxmsdConfig>/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf</netxmsdConfig>     <datasources>         <datasource>             <id>ntxdb</id>             <type>oracle</type>             <url>jdbc:oracle:thin:@//10.80.226.18:1521/uspsq_app</url>             <username>e1010985</username>             <password>one2345</password>         </datasource>     </datasources>     <smtp>         <server>127.0.0.1</server>         <from>[email protected]</from>     </smtp>     <netxms>         <server>127.0.0.1</server>         <login>admin</login>         <password>Awesome@1</password>     </netxms> </config> Thanks Naga reportserver_debugs_with_explicit_path_connection_info.txt

Thank you very much

I still don't understand the meaning of these text labels - but thanks, with the value set to 3.1 everything worked.

Excellent Victor, thanks for your support After making the changes suggested by you, I could see approriate log messages in both agent log and server log Agent log: [06-Aug-2015 23:59:32.636] [DEBUG] [session:0] GetTableValue(): result is 0 (SUCCESS) [06-Aug-2015 23:59:32.637] [DEBUG] [session:0] Sending message CMD_REQUEST_COMPLETED (size 2880) [06-Aug-2015 23:59:33.055] [DEBUG] LogParser: new data avialable in file "/apps/uspsqa1/switch/site/log/sys/SunOSsyslg.log" [06-Aug-2015 23:59:33.055] [DEBUG] SendTrap(): event_code=0, event_name=IST_SYSLG1_RECORD, num_args=1, arg[0]="fatal error" arg[1]="(null)" arg[2]="(null)" [06-Aug-2015 23:59:33.055] [DEBUG] [session:0] Sending message CMD_TRAP (size 144) Server log: g-2015 23:59:06.692] [DEBUG] StatusPoll(s1): bAllDown=false, dynFlags=0x00000001 [06-Aug-2015 23:59:06.694] [DEBUG] StatusPoll(s1 [112]): boot time set to 1438269511 from agent [06-Aug-2015 23:59:06.695] [DEBUG] Finished status poll for node s1 (ID: 112) [06-Aug-2015 23:59:33.056] [DEBUG] AgentConnectionEx::onTrap(): Received trap message from agent at 10.80.226.33, node ID 112 [06-Aug-2015 23:59:33.056] [DEBUG] AgentConnectionEx::onTrap(): trapID is valid [06-Aug-2015 23:59:33.056] [DEBUG] Event from trap: 100066 [06-Aug-2015 23:59:33.056] [DEBUG] CorrelateEvent: event IST_SYSLG1_RECORD id 44 source s1 [112] [06-Aug-2015 23:59:33.056] [DEBUG] CorrelateEvent: finished, rootId=0 [06-Aug-2015 23:59:33.056] [DEBUG] EVENT 100066 (ID:44 F:0x0001 S:0 TAG:"") FROM s1: fatal error [06-Aug-2015 23:59:33.057] [DEBUG] Event 44 match EPP rule 27 [06-Aug-2015 23:59:46.486] [DEBUG] Updating maps... Also could see event being logged in event_log table Regards Naga

I think you are confusing a few things here. application logs (nxagentd or netxmsd) are NOT syslog You can read up on syslog here http://www.networkmanagementsoftware.com/what-is-syslog Application logs (nxagentd or netxmsd) are written as configured in the (nxagentd or netxmsd) conf files. Syslog messages can be sent from any of your devices to NetXMS syslog server. You can of course direct the application logs to be sent over syslog as well (using the {syslog} setting), but correct syslog deamon configuration on your Linux box is needed. On Windows, {syslog} means to use the Windows System Log - which is not syslog at all.

Hi I need to change tooltip of object ( in my case node) that has been added to map I need to change tooltip based on status value of object. Regards Naga

Hi, there are no limit on number of table columns. Can you show full script, maybe problem is elsewhere? Best regards, Victor

Thank you very much.. it works now