NetXMS Support Forum

English Support => General Support => Topic started by: atena on September 14, 2020, 10:06:23 AM

Title: query in netxms
Post by: atena on September 14, 2020, 10:06:23 AM
Hi
I want to have a result of queries from database as an input to DCI
for example I want  the result of this query : "select distinct filename from table_call_lte where end_time between 'Current_time-3 hours' and 'Current_time-2 hours'" to be pushed in DCI
is there any way easier than writing script and job ??
thanks for your answers
Title: Re: query in netxms
Post by: Victor Kirhenshtein on September 14, 2020, 11:32:36 AM
Hi,

you can use DBQuery subagent for it: https://www.netxms.org/documentation/adminguide/application-monitoring.html?highlight=dbquery#application-database-monitoring (https://www.netxms.org/documentation/adminguide/application-monitoring.html?highlight=dbquery#application-database-monitoring)

Best regards,
Victor