Splunk Enterprise Security

Subsearch results not matching special characters

SplunkNewbie18
New Member

Hi,

I'm trying to match email events which may consists of alphabets, numbers and special characters and do a count of the sender. However, those subjects with special characters (i.e. @, ", :, ]) is not picked up although its matching the subsearch condition. Anyone has any idea how to go about matching all character instances? Thanks!

index="A" sourcetype="A1" 
| search 
    [| search index="A" sourcetype="A1" subjects="[xxx]*" 
    | rex field=subjects "((?:\[.*\]\s+)(?<NewEmailSubject>(?:.*)))" 
    | eval subjects=NewEmailSubject
    | eval recipient=sender 
    | table subjects, recipient] 
  | stats values(subject) as subjects count by sender    
  | table sender, subjects, count
0 Karma

darrenfuller
Contributor

can you give a sample or two of data that is failing?

0 Karma

SplunkNewbie18
New Member

Oh sure! Some subjects sample:
1. Email Received @hotmail
2. [Hi!] FYA: 'Free' Ticket

0 Karma
Get Updates on the Splunk Community!

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

  Ready to master Kubernetes and cloud monitoring like the pros?Join Splunk’s Growth Engineering team for an ...

Wrapping Up Cybersecurity Awareness Month

October might be wrapping up, but for Splunk Education, cybersecurity awareness never goes out of season. ...

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

&#x1f5e3; You Spoke, We Listened  Audit Trail v2 wasn’t written in isolation—it was shaped by your voices.  In ...