NetXMS Support Forum

Hi!

I'll test this configuration later today or tomorrow.

Best regards,
Victor

Hi!

Since 0.2.22, you can set NetXMS ODBC database driver not to use unicode by adding

DBDrvParams = unicode=no

to your netxmsd.conf file. I have tested NetXMS server running on Ubuntu Linux with MS SQL 2005 via UNIX ODBC, and it works fine.


Best regards,
Victor

Доброе утро!

Для большого количества агентов желательно увеличить количество потоков, собирающих информацию. Попробуйте выставить параметры сервера (View -? Control Panel -> Server Configuration):

NumberOfStatusPollers = 75
NumberOfDataCollectors = 75
NumberOfConfigurationPollers = 10
NumberOfRoutingTablePollers = 20

Если не поможет, запустите пожалуйста сервер с ключом -D 7 (это включит отладочную информацию), и пришлите netxmsd.log (можно на dump - at - netxms.org).

Hello!

Server caches last values for each DCI, so when console displays them, data is coming directly from server's memory, not from SQL database.
However, you may use something like this:

If you wish to get last values for all DCIs on given node, you can use the following query:


select A.item_id,A.ts,D.idata_value,I.description from
(
select item_id,max(idata_timestamp) as ts from netxms.idata_14 group by item_id
) A
join netxms.idata_14 AS D on A.item_id=D.item_id and D.idata_timestamp = A.ts
join netxms.items AS I on I.item_id = A.item_id


For node with id 14.

You can also define the stored procedure for retrieving last values for given node:

CREATE PROC LastValues
@Id integer
AS
EXEC ('
select A.item_id,A.ts,D.idata_value,I.description from
(
select item_id,max(idata_timestamp) as ts from netxms.idata_' + @Id + ' group by item_id
) A
join netxms.idata_' + @Id + ' AS D on A.item_id=D.item_id and D.idata_timestamp = A.ts
join netxms.items AS I on I.item_id = A.item_id'
)
GO


I'm not good in SQL, so probably there are better way to do this

Best regards,
Victor

Hello!

Try to type TREND in lowercase.

Best regards,
Victor

Очень хорошо Поскольку повторить это у себя мне так и не удалось, и особых идей не было...

Thanks for reporting, I'll fix it.

Best regards,
Victor

Hello!

libnxsnmp.so is not a subagent - it's just our SNMP client implementation used internally by NetXMS server and SNMP-related command line tools (nxsnmpget, nxsnmpset, and nxsnmpwalk). Names of subagent modules always starts with libnsm_.

Best regards,
Victor

Hello!

In this topic (https://www.netxms.org/forum/index.php/topic,485.0.html) you can find description how NetXMS stores collected data in database - probably it should be enough for report generation. If you will need additional information, just to ask me.

Best regards,
Victor

Hello!

You can achieve notification escalation in various ways:

1. If you monitor some DCI, you can define different thresholds with different events, for example one event if CPU utilization exceedes 90% for 1 minute, and other if it exceeds 90% for 10 minutes, and then process these events by sending appropriate emails.
2. You can set timeouts on alarms, and process these timeout events. So, if problem occurs, you create alarm from an event, and if nobody acknowledges this alarm within given timeout period, you get another event which you may process and send another notification (and probably create another alarm with timeout, which will trigger third level of escalation, and so on).
3. If you just need to re-send notifications all the time to same destination for DCI threshold violations, you can simply set "repeat interval" in threshold configuration.

Best regards,
Victor

Hello!

What do you mean by "consolidate SNMP traps"? NetXMS server can log all SNMP traps coming to it - is it what you need?

Best regards,
Victor

Po idee iportitsja dolzno bilo tol'ko odno znachenie - poskol'ku poschitali raznicu mezdu poslednim znacheniem, vzjatim iz 32 bita countera, i pervim 64 bita. Vse posledujuschie po idee dolzni scitatsja normal'no. Script ubirat' ne nado, on perevodit baiti v biti - v etom otnoshenii nichego ne izmenilos' - po preznemu s nodi chitajutsja baiti.

Pohoze ja razobralsja: v properties nodi kakaja versija SNMP stoit - 1 ili 2c? 64bit counteri podderzivaet tol'ko 2c - esli stoit versija 1, to kak raz takoj effekt i budet.

Sudja po snmpwalk - podderzka 64 bit counterov est'. Poproboval na dostupnom mne Cisco switche - rabotaet. Edinstvenno, posle smeni OID v DCI nado pomenjat' ego tip na Unisigned Int64. No v ljubom sluchae on ne dolzen bil perehodit' v sostojanie not supported. A mozno screenshot nastrojki DCI - mozet ja tam kakuju oshibku uvizu?

Ochen' stranno - vrode kak Cisco switchi dolzni podderzivat' ifXTable. A kakaja tochno model' i versija IOS? I chto skazet


nxsnmpwalk -c <community> <switch_address> .1.3.6.1.2.1.31.1.1.1


?