NetXMS Support Forum

Hi,

Is it possible to configure the service only for device discovery ?
This service is currently creating idata tables for each device, and huge records are getting stored in these tables. Is possible to disable the creation of these tables and use the service only for device discovery, software inventory and WMI ?

Thanks,

Ravi

Hi,

if you don't have any data collection configured idata tables should stay empty. If you don't want them to be created at all you can try to switch database into single performance data table mode:

1. Stop netxmsd
2. Run the following query:

UPDATE metadata SET var_value='1' WHERE var_name='SingeTablePerfData';

3. Drop any existing idata_nnn and tdata_nnn tables (tables "idata" and "tdata" should stay).
4. Start netxmsd

Please note that single table mode was intended only for TimescaleDB. Theoretically it should work on any DB, but you are on your own here!

Best regards,
Victor

Thank you victor. I will check it.

Best regards,

Ravi