SSH collect DCI table

[ghcoelho]

Hello this is my first post. Sorry about my English.

I'm having a hard time bringing data from SSH.

These are the data received by the command line.

stat_name, stat_current, stat_peak, stat_peak_time
compression_cpu_pc, 0,0,200514093037
cpu_pc, 8,14,200514092832
fc_mb, 28,71,200514092542
fc_io, 1078,2000,200514092542
sas_mb, 40,124,200514092832
sas_io, 592,2320,200514092642
iscsi_mb, 0,0,200514093037
iscsi_io, 0,0,200514093037
write_cache_pc, 35,46,200514092547
total_cache_pc, 79,80,200514093032
vdisk_mb, 28,71,200514092542
vdisk_io, 1045,1956,200514092542
vdisk_ms, 3,8,200514092642
mdisk_mb, 17,62,200514092832
mdisk_io, 285,1264,200514092907
mdisk_ms, 15,18,200514092737
drive_mb, 40,124,200514092832
drive_io, 592,2320,200514092642
drive_ms, 6,6,200514093037
vdisk_r_mb, 0.33,200514092902
vdisk_r_io, 176,947,200514092907
vdisk_r_ms, 5,11,200514092642
vdisk_w_mb, 26,67,200514092542
vdisk_w_io, 870,1707,200514092542
vdisk_w_ms, 3,6,200514092947
mdisk_r_mb, 3,41,200514092902
mdisk_r_io, 162,952,200514092902
mdisk_r_ms, 10,19,200514092642
mdisk_w_mb, 14,43,200514092552
mdisk_w_io, 122,702,200514092612
mdisk_w_ms, 22,22,200514093037
drive_r_mb, 17,59,200514092832
drive_r_io, 307,1216,200514092907
drive_r_ms, 8,8,200514093037
drive_w_mb, 22,65,200514092552
drive_w_io, 285,1405,200514092612
drive_w_ms, 4,5,200514092742
power_w, 289,289,200514093037
temp_c, 24,24,200514093037
temp_f, 75,75,200514093037
iplink_mb, 0,0,200514093037
iplink_io, 0,0,200514093037
iplink_comp_mb, 0,0,200514093037
cloud_up_mb, 0,0,200514093037
cloud_up_ms, 0,0,200514093037
cloud_down_mb, 0,0,200514093037
cloud_down_ms, 0,0,200514093037

I would like to collect everything and once. Since there are a lot of items and that would not have such a high consumption.

Any help is welcome.

Thank you.

[victor]

Hi,

probably the only way is to create script table DCI. Inside script you can use executeSSHCommand method to get your output as lines and split them into table columns.

Best regards,
Victor