NetXMS Support Forum

English Support => General Support => Topic started by: marcelm on December 07, 2017, 01:25:01 PM

Title: Deteled template still in Data Colections
Post by: marcelm on December 07, 2017, 01:25:01 PM
Hello
I deleted template PINGTIME.
(DC) DataCollection is still polling from this template parameter. I DC is template location unknown. ID was 255.  How can I bulk delete this parameter from all nodes.
Or recretare tempalte with same ID?

Thanks
Title: Re: Deteled template still in Data Colections
Post by: Victor Kirhenshtein on December 07, 2017, 05:28:57 PM
Hi,

you could stop server, then run the following SQL query on NetXMS database:

DELETE FROM items WHERE template_id=255;

then run nxdbmgr check, fix any possible errors, and start server again.

Best regards,
Victor
Title: Re: Deteled template still in Data Colections
Post by: marcelm on December 08, 2017, 08:45:38 AM
Thanks it works :)