Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Nagav

#1
General Support / Query on Alarm Age
July 06, 2017, 09:53:40 PM
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
#2
General Support / DR Node
February 27, 2017, 01:56:38 PM
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 ?
#3
General Support / Query on FindNodeObject
February 23, 2017, 03:20:53 PM
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


#4
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
#5
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 ?
-------------------------------------------
#6
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
#7
General Support / Dashboard drilldown
October 12, 2015, 11:07:30 AM
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

#8
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
#9
General Support / Re: Jasper Usage
September 11, 2015, 01:41:43 PM
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


#10
General Support / mvn package - dependency errors
September 11, 2015, 08:30:04 AM
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 ?

#11
General Support / Jasper Usage
September 08, 2015, 11:21:14 AM
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

1) executed "nxdbmgr set EnableReportingServer 1"
2) created conf folder under "/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2"
3) created workplace folder under ""/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2"
4) created logback.xml under conf folder
5) created nxreporting.xml under conf folder
6) Now the folder looks like

   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 .



7) When I executed "java -jar nxreporting-2.0-M2.jar", it produced several errors, kindly review the errors and
let me know the corrections that I need to do, I have attached output of execution for your review


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
#12
General Support / Re: Gauge size adjustment
September 03, 2015, 03:28:22 PM
Thank you very much
#13
General Support / Gauge size adjustment
September 01, 2015, 03:51:10 PM
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
#14
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
#15
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