DCI values storage path on Debian

Started by duanebutler, August 10, 2016, 01:36:30 PM

Previous topic - Next topic

duanebutler

Good day

Where does netxms save / store dci values on Debian server? what is the file type?

Regards

tomaskir

In the database.

Where/what the database is depends on how you configured netxmsd.conf.

duanebutler

What tables? 

Or let me ask, what format of the tables containing the DCI's?


Alex Kirhenshtein

There is a set of tables for each node ("%d" is replaced with node id, you  can query it from table nodes and table object_properties):

idata_%d - single item DCIs
tdata_%d - table DCIs
tdata_records_%d
tdata_rows_%d

duanebutler

Hi Alex

I just created node 1036. and 3 dci's:

DCI IDs's: 517, 534, 535.

But cant seem to find the table where values are stored.  I have been looking in all your tables described. I can only find the first dci's value in idata_1036.
But not the other 2 values.

Please assist.
Regards