Splunk Enterprise Security

How to filter only one email address domain if you have multiple email address entries

rodrigvi
New Member

How to filter only one email address domain if you have multiple email address entries, example :
I have more than 1000 gmail.com entries. Only I need to filter "gmail.com" domain in splunk , I don't care about other emails. but I don't want to create a filter with 1000 records each for any gmail.com account.

acb@gmail.com
cde@gmail.com
1234@gmail.com
321@yahoo.com
123@yahoo.com
terra@hotmail.com
z@roo@hotmail.com

Thanks for your help

0 Karma

adonio
Ultra Champion

create a new field that matches the domain and search against it ...

form the top of my head:
try this anywhere to see

| makeresults count=1
| eval emails = "acb@gmail.com;;;cde@gmail.com;;;1234@gmail.com;;;321@yahoo.com;;;123@yahoo.com;;;terra@hotmail.com;;;z@roo@hotmail.com"
| makemv delim=";;;" emails
| mvexpand emails
| rex field=emails "\@(?<domain>[^\.]+)"
| search domain=gmail

you might need a better regex for more complex / emails that have the @ in the address itself

0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...