Dashboards & Visualizations

How to stats count email from each domain destination?

chakuttha
Explorer

Hi All,

If i would like to stats count by destination email  and show result by sum each domain (gmail , hotmail )

please help to recommend

 

Best Regards,

CR

 

Labels (1)
Tags (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @chakuttha,

Yout question is just a little vague.

if you could share some sample of your logs I could help you better.

Anyway, you have to run something like this:

<your_search>
| rex "@(?<domain>[^ ]+)"
| stats count BY domain

I'm obviously not sure about regex because I didn't see your logs.

Ciao.

Giuseppe

0 Karma

chakuttha
Explorer

@gcusello 
from log i will see destination email  

Example

example@gmail.com

example2@gmail.com

example3@gmail.com

example4@hotmail.com

 

from log above i would like result from stats query about

dest_email          count
gmail                         3

hotmail                    1

 

Thank you

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...