NetXMS Support Forum

Запрос для MS SQL:


SELECT TOP 200 event_id,event_code,event_name,severity,source_object_id,event_timestamp,message FROM alarm_events WHERE alarm_id=? ORDER BY event_timestamp DESC;



SELECT e.event_id,e.event_code,c.event_name,e.event_severity,e.event_source,e.event_timestamp,e.event_message
FROM event_log e,event_cfg c WHERE e.root_event_id=? AND c.event_code=e.event_code;


Простым образом сделать не получится. Через API можно получить объекты на карте, но отрисовку придется делать самостоятельно.

У меня скрипт отработал нормально (после замены sn на subnet во второй строке). Попробуйте включить дебаг уровня 6 на сервере и посмотреть что на стороне сервера происходит. И какая версия NetXMS? Я проверял на 2.1-М3.

Hi,

are you using instance discovery?

Best regards,
Victor

Hi,

you can define same DCIs on ESXi and set source node to management server. That way actual data collection will occur on management server but data will be shown on ESXi node.

Best regards,
Victor

Hi,

seems to be a bug in the code. What version you are using?

Best regards,
Victor

Hi,

seems that template was somehow removed from object structure but not deleted. Try to login with user system - most likely you will see that template in the root of object tree. Then you'll be able to delete it completely.

Best regards,
Victor

Hi,

please turn on agent crash dumps by adding to nxagentd.conf:

CreateCrashDumps = yes
DumpDirectory = some_path

and send crash dumps (if any) to [email protected]

Best regards,
Victor

Hi,

you have to add object access rights as well. They are assigned in object properties. You can also add your users to Admins group - it should have all object rights assignments already.

Best regards,
Victor

Hi,

you can use instance filter script to modify instance itself or just instance name. For example, if you instance is two numbers connected with dot you can use the following filter script:


instance = $1;
if ($1 ~= "[0-9]+\\.([0-9]+)")
{
   return %(true, instance, $1);
}
return true;


This script will keep instance as is (i.e. 4.2) but set instance name to second number (i.e. 2). You can then use {instance-name} in description to insert updated display name.

Best regards,
Victor

Hi,

alarms are grouped based on alarm key - if alarm with same key already exist when new alarm is generated new alarm will replace existing alarm and increase repeat count. Make sure you have meaningful alarm keys (or empty keys to disable alarm matching).

Best regards,
Victor

Hi,

this is short configuration instruction: https://wiki.netxms.org/wiki/How_to_configure_agent_to_server_connection

Best regards,
Victor

Yes, this is what zones are for. You can have overlapping IP addresses as long as they are in different zones.

Best regards,
Victor

P.S. You can also use Port, Login, and Password parameters in broker section.

Hi,

currently agent can connect to broker and pass published data to server as events or provide additional metrics with received data. You can connect multiple brokers to one agent. For each broker you should create section named MQTT/Broker/broker_name where you'll define broker hostname using Hostname parameter. Then you can use sections MQTT/Broker/broker_name/Events and MQTT/Broker/broker_name/Metrics to map receiving data to events and metrics.

Example MQTT subagent configuration:


SubAgent = mqtt.nsm

[MQTT/Brokers/Office]
Hostname = mqtt.office.radensolutions.com

[MQTT/Brokers/Office/Events]
MQTT_METERHUB_RAW_DATA = "cmnd/5C:CF:7F:25:79:D6/#"

[MQTT/Brokers/Office/Metrics]
MeterHub.Telemetry.RSSI = "tele/5C:CF:7F:25:79:D6/RSSI"
MeterHub.Telemetry.Time = "tele/5C:CF:7F:25:79:D6/TIME"


here agent will subscribe to one broker at address mqtt.office.radensolutions.com, will generate event MQTT_METERHUB_RAW_DATA for each message matching pattern cmnd/5C:CF:7F:25:79:D6/#, and provide two additional metrics MeterHub.Telemetry.RSSI and MeterHub.Telemetry.Time.

Best regards,
Victor