Data Table SELECT possible in Postgresql?

Started by jermudgeon, July 17, 2019, 08:47:27 PM

Previous topic - Next topic

jermudgeon

Does anyone have experience querying DC table data directly using Postgres? I'm working in Grafana, and having good success with non-table DCIs. For complicated reasons I need to be able to create custom queries rather than relying on NetXMS' built-in data export features. By parsing dctable.cpp, I believe I get the gist of how tables are constructed using dc_table_columns, with the cells themselves stored in tdata, but I'm not understanding how the
tdata_value field actually works, or whether it's even possible to parse it outside of NetXMS itself.

Another option would be if the Grafana API plugin for NetXMS supported tables, but I'm not sure anyone's working on that.