NetXMS Support Forum

English Support => General Support => Topic started by: ravi2904 on November 21, 2019, 03:58:59 PM

Title: COnfiguring for only discovery
Post by: ravi2904 on November 21, 2019, 03:58:59 PM
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
Title: Re: COnfiguring for only discovery
Post by: Victor Kirhenshtein on November 22, 2019, 01:42:09 PM
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
Title: Re: COnfiguring for only discovery
Post by: ravi2904 on November 22, 2019, 03:22:13 PM
Thank you victor. I will check it.

Best regards,

Ravi