UNSOLVED

12345fsa

updated

12 years ago

1

12345fsa

19 Posts

0

967

October 24th, 2014 03:00

system show performance to xls

Hi All ,

i'm trying to troubleshoot a performance issue on a DD.

This involve a lot of "system show performance" .

there is any tool / script / whatsoever to convert the output of system show perf to excel ?

Andrea

  • ble1

    6 Operator

    14354 Posts

    56186 Points

    644

    1

    Posted October 24th, 2014 03:00

    To capture output, easiest way is to run this via ssh and redirect output.  Later on you just load it to excel.

  • 12345fsa

    19 Posts

    644

    0

    Posted October 24th, 2014 05:00

    yes , no problem about this , but the output of system show perf is quite ugly , and difficult to parse in excel using fixed widht columns , i.e if one of cpu data is < 10% it shift all the following columns.

    some field have space as separator and some other have / , and so on

    a great option would be the possibilty to create xml/csv output , but it does not seem possible right now

    So i was investigating if someone has already invented the wheel