NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: ExternalTable limitations..  (Read 355 times)

haguru

  • Newbie
  • *
  • Posts: 1
    • View Profile
ExternalTable limitations..
« 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

Logged

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6509
    • View Profile
Re: ExternalTable limitations..
« Reply #1 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
Logged