lingtan
2 Bronze

Can I have .csv output for symstat command?

Jump to solution

I intend to run the following command:

symstat -type REQUEST -sid xxx -i 60 -c 120

Is there a way to specify the output to be in .csv format?

Labels (1)
0 Kudos
1 Solution

Accepted Solutions
M_Salem
3 Argentium

Re: Can I have .csv output for symstat command?

Jump to solution

As Fenglin pointed out, The command you should use is as follows:

1- symstat -type REQUEST -sid xxx -i 60 -c 120 -output xml_e >C:\output.xml

2- Open Output.xml with MS Office Excel.

3- Save As--> Other formats--> .CSV

This should work fine. I tested it on Openoffice as well and it worked fine

Hope it helps

Mohammed Salem   @yankoora

5 Replies
Fenglin1
4 Beryllium

Re: Can I have .csv output for symstat command?

Jump to solution

No, I don't think so. But SE does support XML output with syntax -output xml_element following any SE command display. You can leverage it to make further data procedure.

M_Salem
3 Argentium

Re: Can I have .csv output for symstat command?

Jump to solution

As Fenglin pointed out, The command you should use is as follows:

1- symstat -type REQUEST -sid xxx -i 60 -c 120 -output xml_e >C:\output.xml

2- Open Output.xml with MS Office Excel.

3- Save As--> Other formats--> .CSV

This should work fine. I tested it on Openoffice as well and it worked fine

Hope it helps

Mohammed Salem   @yankoora

Fenglin1
4 Beryllium

Re: Can I have .csv output for symstat command?

Jump to solution

Good to know, Thanks Salem

M_Salem
3 Argentium

Re: Can I have .csv output for symstat command?

Jump to solution

Always welcome Fenglin

0 Kudos
Highlighted

Re: Can I have .csv output for symstat command?

Jump to solution

Hi Lingtan


I have done a similar task you are needing right now. As a general rule almost every SE command can be pointed at the end like this, >filename.txt, which means that the output of the command will be recorded in a TXT file, you could also try to generate .CSV extension

Regards

0 Kudos