topic Alert report - columns not ordered by table command in Alerting

Alert report - columns not ordered by table command

brdr — Mon, 02 Jul 2018 18:03:18 GMT

Hello,

Is there a way to guarantee the columns order in which they are defined by the last command (table) in the search that generates the report/alert? NOTE: I'm formatting the results using inline table.

As always, thank you.

Re: Alert report - columns not ordered by table command

Azeemering — Mon, 02 Jul 2018 18:34:30 GMT

The table command returns a table that is formed by only the fields that you specify in the arguments. Columns are displayed in the same order that fields are specified. Column headers are the field names. Rows are the field values. Each row represents an event.

Example SPL:

Index=farmanimals | table cows, chickens, pigs it will display the table also in that order.
Is it not the case with your query?

Re: Alert report - columns not ordered by table command

brdr — Mon, 02 Jul 2018 18:48:11 GMT

No it is not. In my search that makes up the alert I have this as the last line:

| table 1 2 3 4 5 6 7

The inline table results I receive via email has them in this order:

7 1 2 3 5 4 6

Re: Alert report - columns not ordered by table command

n0vsec — Wed, 16 Sep 2020 23:10:42 GMT

Were you able to resolve this?

Re: Alert report - columns not ordered by table command

AllenZhang — Thu, 22 Apr 2021 22:39:21 GMT

I just noticed the same issue.

it's fine as search result.

But not in the same order in the email as inline table received by scheduled report.

Re: Alert report - columns not ordered by table command

AllenZhang — Mon, 26 Apr 2021 20:51:24 GMT

In my case,

index=example | table SID Auto Manual Total

Everything looks fine on web. However in email as inline, it shows:

Auto Total SID Manual