Text only | Text with Images

NetXMS Support Forum

English Support => General Support => Topic started by: duanebutler on August 10, 2016, 01:36:30 PM

Title: DCI values storage path on Debian
Post by: duanebutler on August 10, 2016, 01:36:30 PM
Good day

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

Regards
Title: Re: DCI values storage path on Debian
Post by: tomaskir on August 10, 2016, 01:51:47 PM
In the database.

Where/what the database is depends on how you configured netxmsd.conf.
Title: Re: DCI values storage path on Debian
Post by: duanebutler on August 10, 2016, 05:29:10 PM
What tables? 

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

Title: Re: DCI values storage path on Debian
Post by: Alex Kirhenshtein on August 11, 2016, 01:54:25 PM
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
Title: Re: DCI values storage path on Debian
Post by: duanebutler on September 01, 2016, 11:52:16 AM
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

Text only | Text with Images