topic Re: Sendemail changing column order in Reporting

Sendemail changing column order

sscandoit — Fri, 26 Aug 2011 19:53:56 GMT

Hi,

I am using sendemail command in my search to send results as CSV file. I read the following post which states that prior to version 4.1.4 sendemail orders the results as per column length.

link:Define field order on export

I replaced the generateHTMLResults with the code from sendemail.py from 4.2 version which doesn't sort the columns. However this didn't work.

Can you please tell me how can I display the columns same as given in table command?

Thanks

Suvelee

Re: Sendemail changing column order

fk319 — Mon, 29 Aug 2011 13:17:13 GMT

right before your sendmail command, try using 'fields <field_list>'

Re: Sendemail changing column order

sscandoit — Tue, 30 Aug 2011 13:27:14 GMT

Thanks for the reply. Tried using fields as you suggested, but that didn't work.

Re: Sendemail changing column order

aminobtata — Tue, 13 Dec 2011 18:56:02 GMT

Hi,

I have the same problem :
When I use stats or chart function in splunk my columns displayed in the good order. But if I export the result to CSV sometimes the columns order change.

Please if someone know how to force columns order when using OPTION "-output csv" in search command.
How did you fix it !

Best Regard

Re: Sendemail changing column order

aminobtata — Tue, 13 Dec 2011 18:56:10 GMT

Hi,

I have the same problem :
When I use stats or chart function in splunk my columns displayed in the good order. But if I export the result to CSV sometimes the columns order change.

Please if someone know how to force columns order when using OPTION "-output csv" in search command.
How did you fix it !

Best Regard