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

Get Updates on the Splunk Community!

Index This | I’m short for "configuration file.” What am I?

May 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with a Special ...

New Articles from Academic Learning Partners, Help Expand Lantern’s Use Case Library, ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...