Hi
I am trying to write SQL that will collect how much time each alarm (that got triggered) took to get resolved ( time difference between time of when it got triggered and time of when it got resolved)
Basically I am trying to get table like this
Alarm_id | Alarm_message | Time it got Triggered |Time it got Resolved Age ( difference between two times) |
Can you please help me with SQL ?
I did spent time looking at Alarm and Alarm_events tables, but I could not frame correct query
Hi
How to handle DR switchover
Assume I have done complete configuration of active node.. and assume active node is up and running and netxms DCI's are collecting data.
When DR failover take-place active node becomes inactive and node at DR site become active
From netxms perspective what I should do ? Is it enough if I change the IP address of active node configuration to point to DR node and do Poll configuration?
Or should I Maintenance Separate node in NetXMS for DR site and maintain all configuration for that also and bring it up when DR failover take-place
Your advise please ?
When I try add script DCI to set Object status, I am getting following error
Script (DCI:POS_NODE_STATUS) execution error: Error 14 in line 3: Function or operation argument is not an object
Script POS_NODE_STATUS script in lib is :
pnode = FindNodeObject($node,"sw");
dciName = "IST Port status";
dciId = FindDCIByDescription(pnode, dciName);
dciObj = GetDCIObject(pnode, dciId);
if (dciId == null) return 0;
tableOld = GetDCIValue(pnode, dciId);
if (tableOld == null) return 0;
I try to execute first few line of above script in Transformation window for checking purpose, I noticed that FindNodeObject does not able to find object “sw”, I tried same by giving object id also, but still output of script is null, I have attached screenshot of script execution result and "sw" object properties
Can you please let me know why FindNodeObject function count not find the object ?
Also can you please help me to correct above script, if it requires any change
Hi
Is it not possible to add more than 10 columns using $1->addColumn("Column Name"); ?
If I try to add 11th column and set value to it using transfermation script, it is not getting displayed in Table latest value
How to add 11th column ?
Thanks
Naga
I have .tnsnames.ora file in my local home directory
[vlltcmpsswtdap01.atldev.com]/home/swdev/istnetxms/agent205/netxms/log> cd
[vlltcmpsswtdap01.atldev.com]/home/swdev>
[vlltcmpsswtdap01.atldev.com]/home/swdev> ls -ltra | grep tns
-rw-rw-r-- 1 swdev swdev 375 Nov 30 15:47 .tnsnames.ora
I have following entry in .tnsnames.ora
MPSDEV1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lltcdevoda1-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mpsdev1)
)
)
Using DBQuery I am tring to connect to above database
I gave following entry in agent configuration file
*DBQUERY
Database = id=MPSDEV1;driver=oracle.ddr;server=10.7.68.65;login=Netxms;Password=mpsdev
Query = query1:MPSDEV1:5:SELECT count(*) FROM containers
when I started agent I got following error
[15-Dec-2015 00:27:51.709] [WARN ] DBQUERY: cannot connect to database MPSDEV1 (ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA)
[15-Dec-2015 00:27:51.709] [DEBUG] DBQUERY: Query::poll(query1): no connection handle for database MPSDEV1
I tried giving id as SID also
*DBQUERY
Database = id=mpsdev1;driver=oracle.ddr;server=10.7.68.65;login=Netxms;Password=mpsdev
Query = query1:mpsdev1:5:SELECT count(*) FROM containers
But still I got same error in debug file
[WARN ] DBQUERY: cannot connect to database mpsdev1 (ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA)
[DEBUG] DBQUERY: Query::poll(query1): no connection handle for database mpsdev1
For setting up subagent I refered to example given in admin guide, is the info given in admin guide is correct ? what I am missing in subagent configuration
why DBQUERY subagent could not identify the TNS entry ?
---------------------------------------
Configuration Example
# This sample nxagentd.conf instructs agent to:
# 1. load DBQuery subagent
# 2. Define two databases - db1 (Oracle) and db2 (MySQL).
# 3. Execute query "SELECT f1 FROM table1" in database db1 every 60 seconds
# 4. Execute query "SELECT f1 FROM table2 WHERE f2 LIKE ':%'" on DSN2 every 15 seconds
MasterServers = netxms.demo
SubAgent = dbquery.nsm
*DBQUERY
Database = id=db1;driver=oracle.ddr;server=10.0.0.2;login=netxms;encryptedPassword=H02kxYckADXCpgp+
Database = id=db2;driver=mysql.ddr;server=10.0.0.4;dbname=test_db;login=netxms;password=netxms1
Query = query1:db1:60:SELECT f1 FROM table1
Query = query2:db2:15:SELECT f1 FROM table2 WHERE f2 LIKE ':%'
ConfigurableQuery = query3:db2:Comment in param:SELECT name FROM images WHERE name like ?
-------------------------------------------
Hello Team
I am trying to use "Show Theshold" option in line graph, it seems that it is not working, I am not sure whether my expection on setting up this option correct or not
With query I have attached screenshot of setting that i have for line gragh
my expection is that there should be striate line should appear in line graph for the value set in theshold, but it is working working
is my expection is correct ?
Regards
Naga
Hi Team
In Dashboard graphs, it is possible to have drilldown feature ?
(like if we right click on line graph and select some option it should take to another dashboard graphs)
Regards
Naga
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
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
I am process of preparing .jar file which required to be placed under definations folder, when I tried to do so, I am facing few dependency errors, I am not sure whether those dependency are required or not
I have tried to do "mvn package of "Data collection configuration" given in sample_reports.tar.gz of "Re: Install report server - Part 2 – report definitions" discussion
When I try to do so I got error
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building Data Collection Report 1.0.0
[INFO] ------------------------------------------------------------------------
[WARNING] The POM for com.radensolutions:nxreporting:jar:2.0-SNAPSHOT is missing, no dependency information available
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 0.470 s
[INFO] Finished at: 2015-09-11T09:05:20+05:30
[INFO] Final Memory: 5M/15M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project dci: Could not resolve dependencies for project org.netxms.report:dci:jar:1.0.0: Could not find artifact com.radensolutions:nxreporting:jar:2.0-SNAPSHOT -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
if I remove the dependency
<dependencies>
<dependency>
<groupId>com.radensolutions</groupId>
<artifactId>nxreporting</artifactId>
<version>2.0-SNAPSHOT</version>
<scope>compile</scope>
</dependency>
</dependencies>
build gets completed successfully following error
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building Data Collection Report 1.0.0
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- gmavenplus-plugin:1.4:execute (set-build-uuid-property) @ dci ---
[ERROR] Unable to determine Groovy version. Is Groovy declared as a dependency?
[ERROR] Unable to determine Groovy version. Is Groovy declared as a dependency?
[ERROR] Unable to determine Groovy version. Is Groovy declared as a dependency?
[ERROR] Unable to determine Groovy version. Is Groovy declared as a dependency?
[ERROR] Your Groovy version (null) doesn't support script execution. The minimum version of Groovy required is 1.5.0. Skipping script execution.
[INFO]
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ dci ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 2 resources
[INFO]
[INFO] --- maven-compiler-plugin:3.1:compile (default-compile) @ dci ---
[INFO] No sources to compile
[INFO]
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ dci ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory C:\mproject\dci\src\test\resources
[INFO]
[INFO] --- maven-compiler-plugin:3.1:testCompile (default-testCompile) @ dci ---
[INFO] No sources to compile
[INFO]
[INFO] --- maven-surefire-plugin:2.12.4:test (default-test) @ dci ---
[INFO] No tests to run.
[INFO]
[INFO] --- maven-jar-plugin:2.5:jar (default-jar) @ dci ---
[INFO] Building jar: C:\mproject\dci\target\dci-1.0.0.jar
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3.332 s
[INFO] Finished at: 2015-09-11T09:11:45+05:30
[INFO] Final Memory: 8M/20M
[INFO] ------------------------------------------------------------------------
Now can I post this created Jar file under definiations folder ?
Hello
Can you please point me to document, that will provide me help me/ guide me to implement reporting feature (using Jasper report's .jxml files). Not sure from where I need to start. It will great if there is any tutorial kind of document.
Currently I am using Netxms window client version 2.0-M2(8008)
I have done following
from "https://www.netxms.org/download/archive/reporting/" I have download "netxms-reporting-server-2.0-M2.zip"
I have unziped it in Window and copied it to unix box where my netxms server (ntxmsd) is running
copied it to location /apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2
and did following steps
uspsqa1@mkeux805n-z1-76-SWITCH>> ls -ltra
total 5920
drwxr-xr-x 11 uspsqa1 uspsqa1 34 Sep 9 02:33 ..
-rw-r--r-- 1 uspsqa1 uspsqa1 2929061 Sep 9 02:33 nxreporting-2.0-M2.jar
drwxr-xr-x 5 uspsqa1 uspsqa1 6 Sep 9 02:33 .
drwxr-xr-x 2 uspsqa1 uspsqa1 79 Sep 9 02:33 lib
drwxr-xr-x 2 uspsqa1 uspsqa1 4 Sep 9 02:48 conf
drwxr-xr-x 4 uspsqa1 uspsqa1 4 Sep 9 02:49 workplace
/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace
uspsqa1@mkeux805n-z1-76-SWITCH>> ls -ltra
total 13
drwxr-xr-x 5 uspsqa1 uspsqa1 6 Sep 9 02:33 ..
drwxr-xr-x 2 uspsqa1 uspsqa1 2 Sep 9 02:49 definitions
drwxr-xr-x 2 uspsqa1 uspsqa1 2 Sep 9 02:49 output
drwxr-xr-x 5 uspsqa1 uspsqa1 5 Sep 9 02:49 .
Also here are the content of my nxreporting.xml and logback.xml,
The path "/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf" valid path were I have server configuration
I have not given <datasource> info beacause I read that database details be collected from server configuration
content of "nxreporting.xml"
<config>
<workspace>/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace</workspace>
<netxmsdConfig>/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf</netxmsdConfig>
<datasources>
<datasource>
</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>
content of "logback.xml"
<configuration>
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<!-- encoders are assigned the type
ch.qos.logback.classic.encoder.PatternLayoutEncoder by default -->
<encoder>
<pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
</encoder>
</appender>
<root level="debug">
<appender-ref ref="STDOUT" />
</root>
</configuration>
Regards
Naga
Thank you very much
Hello
Please find attached screenshot of one of our dashbaord, where I have one line chart and 3 gauges inserted in it
I could see 3 gauges are in different size, is it possible to get them in same size
from left to right size of gauges get increased
Layout of all 3 gauges are same but still I see difference in size
thanks
Naga
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
Hi
Just now I noticed that
if I comment out server name in server and control list
I see following logs in agent and DCI's did not collect data
[06-Aug-2015 05:20:36.789] [DEBUG] Connection from 127.0.0.1 rejected
[06-Aug-2015 05:20:36.789] [DEBUG] Incoming connection from 127.0.0.1
[06-Aug-2015 05:20:36.789] [DEBUG] Connection from 127.0.0.1 rejected
[06-Aug-2015 05:20:36.789] [DEBUG] Incoming connection from 127.0.0.1
[06-Aug-2015 05:20:36.789] [DEBUG] Connection from 127.0.0.1 rejected
[06-Aug-2015 05:20:36.790] [DEBUG] Incoming connection from 127.0.0.1
[06-Aug-2015 05:20:36.790] [DEBUG] Connection from 127.0.0.1 rejected
[06-Aug-2015 05:20:36.790] [DEBUG] Incoming connection from 127.0.0.1
[06-Aug-2015 05:20:36.790] [DEBUG] Connection from 127.0.0.1 rejected
[06-Aug-2015 05:20:36.791] [DEBUG] Incoming connection from 127.0.0.1
[06-Aug-2015 05:20:36.791] [DEBUG] Connection from 127.0.0.1 rejected
[06-Aug-2015 05:20:36.791] [DEBUG] Incoming connection from 127.0.0.1
[06-Aug-2015 05:20:36.791] [DEBUG] Connection from 127.0.0.1 rejected
[06-Aug-2015 05:20:36.792] [DEBUG] Incoming connection from 127.0.0.1
[06-Aug-2015 05:20:36.792] [DEBUG] Connection from 127.0.0.1 rejected
[06-Aug-2015 05:20:36.792] [DEBUG] Incoming connection from 127.0.0.1
[06-Aug-2015 05:20:36.792] [DEBUG] Connection from 127.0.0.1 rejected
Thanks
Naga
Hi Victor
Tried your suggestion, still I could see only two line in agent log file
[06-Aug-2015 05:00:21.367] [DEBUG] LogParser: new data avialable in file "/apps/uspsqa1/switch/site/log/sys/SunOSsyslg.log"
[06-Aug-2015 05:00:21.367] [DEBUG] SendTrap(): event_code=0, event_name=IST_SYSLG1_RECORD, num_args=1, arg[0]="fatal error" arg[1]="(null)" arg[2]="(null)"
Regards
Naga
Hi Victor
Attached nxagentd.conf file and word doc that has screenshot of node property and node configuration poll details
Regards
Naga
Hi Victor
Thanks, it works
Regards
Naga
Hi
In Gauge – Dial type, I have following setting
Min value as 0.0
Max value as 250.0
Left red zero end as 0.0
Left yellow zero end as 0.0
Right yellow zone start as 150.0
Right red zone start as 200.0
With above setting I got dial as
0 to 150 – with green color
150 to 200 – with yellow color
200 to 250 – with red color
But I have requirement where I need to get
0 to 150 – with red color
150 to 200 – with yellow color
200 to 250 – with green color
What value I need to change to get dial with above my requirement? Is it possible? In our case as the value decrease it is more risk and its color should be red.
