Other Usage

How to hide a column in the email

manojchacko78
Path Finder

Hello

I have created an email alert and the recipients are pulled from the search results.  Below is the part of the search query

| stats count by CreateTimestamp  CCRecipients
| rename CCRecipients as Recipients
| table CreateTimestamp Recipients
| fields - count

and in the email alert configuration i added this $result.Recipients$ under the CC field

Now without having Recipients in the search results, i cannot parse it in the CC field.

So now when the mail gets triggered, the values in Recipients are getting displayed as part of the table, now do i mask this from appearing in the email?

Labels (3)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Try this

| stats count by CreateTimestamp  CCRecipients
| rename CCRecipients as _Recipients
| fields - count

Then add this $result._Recipients$ under the CC field

View solution in original post

manojchacko78
Path Finder

The issue is resolved, thanks a lot.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try this

| stats count by CreateTimestamp  CCRecipients
| rename CCRecipients as _Recipients
| fields - count

Then add this $result._Recipients$ under the CC field

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...