NetXMS Support Forum

English Support => General Support => Topic started by: haguru on July 17, 2018, 11:30:27 PM

Title: ExternalTable limitations..
Post by: haguru on July 17, 2018, 11:30:27 PM
Hi. New user and I just first of all want to say "thank you". This is probably the best NMS I've ever used in my life (and I've been doing this for over 20 years now). You guys have really outdone yourself and I'm annoyed that I'm just now finding out about this tool. You guys are sure to see some donations from me in the future.
So I've been working on an ExternalTable to collect SmartData from NVME drives in the environment.
I'm wondering if there is a maximum number of tables that the feature will work with because everything looks in order:

ExternalTable=SmartData:instanceColumns=Smart;description=description;separator=|:perl /tmp/get_smart_data.pl

[root@esos2 ~]# perl ./get_smart_data.pl
critical_warning |temperature |available_spare |available_spare_threshold |percentage_used |data_units_read |data_units_written |host_read_commands |host_write_commands |controller_busy_time |power_cycles |power_on_hours |unsafe_shutdowns |media_errors |num_err_log_entries |WarningTemperatureTime |CriticalCompositeTemperatureTime |ThermalManagementT1TransCount |ThermalManagementT2TransCount |ThermalManagementT1TotalTime |ThermalManagementT2TotalTime
0 |31C |100 |10 |0 |3798552 |16570623 |81578893 |481212853 |12 |15 |4268 |14 |0 |0 |0 |0 |0 |0 |0 |0

But I cannot get it to show me columns beyond the column "media_errors" when viewing the table properties under Data Collection Configuration.  And when list the table data, I can see that "num_err_log_entries" is truncated to "n" and the remainder of the columns seem to be treated like metrics?

See the link below as an example:

https://snag.gy/QSBw0b.jpg

Title: Re: ExternalTable limitations..
Post by: Victor Kirhenshtein on July 18, 2018, 02:45:12 PM
Hi,

just fixed it. For historical reasons (part of the code was written when there were no external tables, only external parameters) line length was limited to 255 characters when read from external script. In version 2.2.7 it is extended to 32K.

Best regards,
Victor