NetXMS Support Forum

Hello Victor, can you explain me how to perform those steps. Thanks.

Hello, yes, yesterday I tried  perform the discovery with SNMPWalk-OID but didnt work. Today, after reading your answer, I tried again and this time it work (I dont remember what was the difference between the code that I was trying yesterday and the current to make them work):


imag

The only doubt that I have regarding this is how to convert the base DCI in template. I tried to add with the option "convert to template item" but dont allow me, it dont appear in the template group that I choose.

Thanks for the advice.

Regards.

Hello, ¿¿ is there a way to discover instances from OIDs with more than one index??

Regards.

Hello, thanks for your answer. In those cases, which is the best practice ??. Also, is there any procedure in the documentation to perform that action ??

Regards.

Hello, here is the netxmsd log file requested: https://www.dropbox.com/s/t3uont26zsu72vs/netxmsd?dl=0

Regards.

Hello, I solved the DCI disabled, by copy them to an unmanaged node, then deleting it in the original node, and finally copy the DCI from the unmanaged node, activating and rediscover the instances again, reboot the system, and the DCIs keep activated.

The autentication issue persists after reboot.

Regards.

Hello:

Follow this guide , it worked for me: https://wiki.netxms.org/wiki/Add_new_MIBs

Hello NETXMS team, I continue working with NETXMS and it start give me the required SNMP monitoring that I was looking for. Thanks you for this tool.

However I just find out that, for two nodes, even if I leave all their DCI activated, after a reboot of the Debian8 (where I installled NETXMS), their DCIs appear as "disabled" again:

1) Before Debian reboot: Their DCIs are activated (in fact, I activated again since they appeared disabled in the last reboot)





2) After Debian rebbot: The DCIs appear disabled again:





In addition , every time the OS is restarted, I have to reload the netxms service for enable access through the Management Console (on the contrary, a message "conection refused" appear). I found the netxms service status different after I restart it:



NETXMS-TEST:~$ sudo service netxmsd status
[sudo] password for admtelcisco:
â netxmsd.service - LSB: NetXMS server
   Loaded: loaded (/etc/init.d/netxmsd)
   Active: active (exited) since Sun 2016-05-22 19:12:52 COT; 5min ago
  Process: 613 ExecStart=/etc/init.d/netxmsd start (code=exited, status=0/SUCCESS)
NETXMS-TEST:~$
NETXMS-TEST:~$ sudo service netxmsd restart
NETXMS-TEST:~$
NETXMS-TEST:~$ sudo service netxmsd status
â netxmsd.service - LSB: NetXMS server
   Loaded: loaded (/etc/init.d/netxmsd)
   Active: active (running) since Sun 2016-05-22 19:18:21 COT; 3s ago
  Process: 1787 ExecStop=/etc/init.d/netxmsd stop (code=exited, status=0/SUCCESS)
  Process: 1796 ExecStart=/etc/init.d/netxmsd start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/netxmsd.service
           ââ1802 /usr/bin/netxmsd -d




How those two issues could be fixed??


Regards.

Hello, I just finished yesterday my issue with DCIs, when I found that the db and hdd usage of my debian system where I mounted NetXMS grow very fast in less than 1 week. When I installed the fresh debian and NetXMS, the disk spase was almost 12% (of 30GB), and yesterday, the usage was in 63% !!:



mysql> SELECT table_schema "Database Name", SUM(data_length+index_length)/1024/1024
    -> "Database Size (MB)"  FROM information_schema.TABLES GROUP BY table_schema;
+--------------------+--------------------+
| Database Name      | Database Size (MB) |
+--------------------+--------------------+
| information_schema |         0.00878906 |
| mysql              |         0.67379189 |
| netxms             |     12664.09375000 |
| performance_schema |         0.00000000 |
+--------------------+--------------------+
4 rows in set (15.80 sec)

$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda1        29G   17G   10G  63% /




I suspect first of the DCI tables that I had in retention mode of 30 days, and I changed it to dont store in db, and also did "Clear collected data" on the DCI but the size didnt decrease. I also run nxdbmgr check and nothing, then I deleted the tables and nothing.

Is there any that I can do to free all that space taken for the db without forcing drop the db??. With this I learned that dci tables take a lot of db space and the next time I put in retention mode: not store in db.

Regards.

Quote from: Andreas@rc on May 02, 2016, 10:58:51 AM
Instead of using your script within the transformation section, why not create a DCI, which executes your script?

This way, you can use the default method for history and graphing from NetXMS.

Thanks for your answer. And yes, I did it yesterday and it worked.

I created first this script with the function count, so I can reuse it:




sub CALL_ACTIVE_COUNT(CALL_ACTIVE_TABLE,CALL_ACTIVE_PEER_ID,CALL_TYPE_ID)
{
COUNT=0;

for(i = 0; i < CALL_ACTIVE_TABLE->rowCount; i++)
{
if (CALL_ACTIVE_TABLE->get(i,CALL_ACTIVE_TABLE->getColumnIndex(CALL_ACTIVE_PEER_ID))==CALL_TYPE_ID)
{
COUNT=COUNT+1;
}

}

return COUNT;
}




Then I created this script as source for the DCI Configuration of my node, and thats is how I could obtain performance graphs:




use CUBE_CALL_ACTIVE_COUNT;

sub main()
{
  LOCAL_ACTIVE_CALLS=CALL_ACTIVE_COUNT(GetDCIValue($node,FindDCIByDescription($node, "CALL-ACTIVE-TABLE-1")),"CALL-ACTIVE-PEER-ID",5);

   return LOCAL_ACTIVE_CALLS;
}



Hello NetXMS Team


In the past days I was able to write this script for counting the times a value is present in a DCI Table Column. Here are the steps Im following:

1) I arrived to this function declared in the CUBE_FUNCTIONS_1 script (I'm planning reusing this function many times):

sub CALL_ACTIVE_COUNT(CALL_ACTIVE_TABLE,CALL_ACTIVE_PEER_ID,CALL_TYPE_ID)
{
   COUNT=0;
   
   for(i = 0; i < CALL_ACTIVE_TABLE->rowCount; i++)
   {
      if (CALL_ACTIVE_TABLE->get(i,CALL_ACTIVE_TABLE->getColumnIndex(CALL_ACTIVE_PEER_ID))==CALL_TYPE_ID)
      {
         COUNT=COUNT+1;
      }   
            
   }
   
   return COUNT;
}


2) Now, in the DCI Table configuration, I used this function to count the times that value '5' is find in the selected column and return me that count:




3) Here, this is value I need to graph , but I dont know how use that value in a graph, even reading all the documentation many times.


Sorry if my posts are not completely understood at first sight, that because Im tired to trying myself the configurations many times,  reading the documentation, the forum, the videos, and not find in the moment what Im looking for, and I need that some tool (like NetXMS) could report me the SNMP metrics as fast as possible. I changed the title again to help you read my issue.


Regards.

Hello NetXMS Support Community

I just start to work with scripts, but I cannot achieve yet the way to count the times that some value appears in a  DCI Table column: Here is the idea that I have but I cannot translate to NetXMS code:

1) From a DCI Table column, get the times that "x" value appears in that column.
2) Store the value and graph it.


Thanks.

Hello, Im starting working with scripts but I just found that the server console is present in the "Tools" menu of the management Console, but not in the Web GUI. Somebody knows why??

Also, I search and the only way that I found to execute a script in the web gui was clicking the secondary button and selecting the "execute server script".

Regards.

Hello, thanks you for the advice.

I created the DCI with the Base OID of .1.3.6.1.2.1.10.21.1.3.1.1.10 and it worked. Also I get the values from the table .1.3.6.1.4.1.9.9.63.1.3.2 (with Base OID .1.3.6.1.4.1.9.9.63.1.3.2.1.42). It seems to me , that the DCI works best when base OIDs are integers.

The other thing was that, when I tried to add the OID .1.3.6.1.2.1.10.21.1.3.1.1.11 as column, NETXMS returned me the error "Not Supported", in all data types.

In addition I found in NETXMS those strange values on the OIDs .1.3.6.1.4.1.9.9.63.1.3.2.1.31 (HEX-STRING, returns only "?") and .1.3.6.1.4.1.9.9.63.1.3.2.1.1 (String but not readable), however I can poll them fine in manageengine mibbrowser. They are not critical for me, so I only post here as information.


Regards.

Hello, thanks for your answer. I'll try to explain again what its the issue and the complete configuration in NetXMS:


1) I need to query the following OID ( that is a SNMP Table) .1.3.6.1.2.1.10.21.1.3.1 , called "callActiveTable" (belong to the DIAL-CONTROL-MIB). My device is already uploaded and discovered in NetXMS via SNMPv3


2) I tried to configure the DCI for this table, but I found (later) in my Mib Browser that the table doesnt have one index (as is explained in https://wiki.netxms.org/wiki/Creating_SNMP_table_DCI), but two (callActiveSetupTime  and callActiveIndex), and the callActiveSetupTime is in timetick/timestamp format.


3) However, I followed the guide and created the DCI with each one of these indexes as base OID  (callActiveSetupTime have OID .1.3.6.1.2.1.10.21.1.3.1.1.1 and callActiveIndex .1.3.6.1.2.1.10.21.1.3.1.1.2), but neither I can obtain data from this table in NetXMS. I already posted this result in the thread:



I also tested the DCI with the iftable and it worked (however, it has only one index)


4) I already query the device via snmpwalk from my debian system where I installed NetXMS and it returned me all the values. Also I query the OIDs with manage engine mib browser and the device return me the values.


I hope that this explanation clarifies more my issue. Even I changed the title of the thread if it is more meaningful.

Regards.