How do I add host and description of error code in telegram alert?

[sphiwee]

I have the below query for an alert, but the result does not add host or description in the result, how can i achieve this?

[richgalloway · Accepted solution]

There are two reasons why the host and description fields are not shown.

1) The stats command removed them.  stats is a transforming command that only passes on the field explicitly mention - in this case count and status.

2) The table command only displays the caption field.

The fixes for host are pretty straightforward - add the field to the stats and table commands.

... | stats count by host, status
...
| table host, caption

Adding the description field likely can be done in a similar manner, but the screenshot tells us nothing about that field so it's hard to say for sure.