ExternalTable limitations..

Started by haguru, July 17, 2018, 11:30:27 PM

Previous topic - Next topic

haguru

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


Victor Kirhenshtein

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