NetXMS Support Forum

English Support => General Support => Topic started by: gmonk63 on September 13, 2022, 07:01:01 PM

Title: Netxms Grafana
Post by: gmonk63 on September 13, 2022, 07:01:01 PM
It it possible to get  access to Netxms raw data for Grafana queries ? I am currently using timescale and I would like to show metrics on total number of devices total number of critical alarms and so forth.  This more of a dummy board for the higher ups so at  a glance they can gauge an over all health status. It does not look like custom queries can be performed.  But it would be a nice addition if we can query data we are interested in assuming we know the schema of the netxms database 


Thanks 
Title: Re: Netxms Grafana
Post by: Victor Kirhenshtein on October 21, 2022, 04:26:41 PM
I suppose you can query timescale directly. Data dictionary can be accessed here: https://www.netxms.org/documentation/datadictionary/ (https://www.netxms.org/documentation/datadictionary/)
You are interested in table idata_sc_default (or view idata), and likely object_properties, items, and nodes.

Best regards,
Victor