NetXMS Support Forum

Dear all,

i have 2 question regards the utilization of Netxms

The first is the utilization of the Subagent for monitoring the database (not NetXMS server db) but another instance deploy in another Host .I need to understand what i can configure and where (side agent into the host ) and side server into the nxmc .For example i need to know if the sqlServer instance rather then oracle instance is running and also the query for check the dimension of tablespace rather then simply query in user table.

The second is the Summary of alarm state . I need for example that every day at 12:00 PM an event send me (by email) the status of specific application server . This status is the situation of the system not necessary must in alarm state.


Best Regards

FL

Hi!

Quote from: ages77 on March 28, 2018, 09:53:01 PM
The first is the utilization of the Subagent for monitoring the database (not NetXMS server db) but another instance deploy in another Host .I need to understand what i can configure and where (side agent into the host ) and side server into the nxmc .For example i need to know if the sqlServer instance rather then oracle instance is running and also the query for check the dimension of tablespace rather then simply query in user table.

What database exactly? There are sub-agents for monitoring Oracle, DB2, and MySQL databases. Also, you can use "dbquery" subagent to issue any query in database, so if you know how to extract data from system tables you can use that as well. For monitoring MS SQL Server you can use Windows Performance counters (accessible via "winperf" subagent).

Quote from: ages77 on March 28, 2018, 09:53:01 PM
The second is the Summary of alarm state . I need for example that every day at 12:00 PM an event send me (by email) the status of specific application server . This status is the situation of the system not necessary must in alarm state.

You can setup scheduled task that will run your script. Script can collect necessary data and generate an event that can be processed as usual and email can be generated from it.

Best regards,
Victor

Hi Victor,

i configure the sub-agent DBQuery for an application istance of sqlServer and i understand what i do .
if I were so kind to post me a simple example of how I could ping a series of hosts at a certain time of day (eg 12:00 PM) and create an event that then send an email with the host states.

thx

Ages77

You can use PING subagent and configure set of Icmp.Ping DCIs in the server, one for each host. You can use custom schedule to collect data once a day at 12:00, and configure threshold as necessary. Relevant part of the documentation: https://www.netxms.org/documentation/adminguide/icmp-ping.html

Best regards,
Victor

Hi Victor,

How can generate an custom event from a script?

Best Regards

Ages77

I suppose you mean NXSL script? Then you can use function PostEvent (https://wiki.netxms.org/wiki/NXSL:PostEvent).

Best regards,
Victor