Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Splunk Search
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Help with Rex or RegEx: How do I extract all lines...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
arrowecssupport
Communicator
06-14-2016
02:19 AM
So my email using the iMail Mailbox comes in with headers like this.
I need everything after the "____________________ Message Body ____________________"
How can I look for this?
blah blah blah
MIME-Version = "1.0"
mailbox = "Inbox"
size = 23156
____________________ Message Body ____________________
Scanning server: xxxx
Time: Tue Jun 14 11:01:46 2016
Sender: xxxx
Recipient(s): xxx
Subject: xxx
File(s):xxxx
Other: Attachment: xxxx
GENERATED_ON=Tue Jun 14 11:00:33 CEST 2016
VERSION=xxx
SYSTEM_xxx
SERIAL_NUMxxxx
HOSTNAME\xx
SEQUENCE\xx
PARTNER_SYSTEM_xxx
PARTNER_SERIAL_NUM=xxxx
PARTNER_HOSTNAME\xxx
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
javiergn
Super Champion
06-14-2016
02:26 AM
Let me know if this is what you are looking for:
| stats count | fields - count
| eval _raw = "blah blah blah
MIME-Version = \"1.0\"
mailbox = \"Inbox\"
size = 23156
Message Body
Scanning server: xxxx
Time: Tue Jun 14 11:01:46 2016
Sender: xxxx
Recipient(s): xxx
Subject: xxx
File(s):xxxx
Other: Attachment: xxxx
GENERATED_ON=Tue Jun 14 11:00:33 CEST 2016
VERSION=xxx
SYSTEM_xxx
SERIAL_NUMxxxx
HOSTNAME\xx
SEQUENCE\xx
PARTNER_SYSTEM_xxx
PARTNER_SERIAL_NUM=xxxx
PARTNER_HOSTNAME\xxx
"
| rex field=_raw "(?msi)Message Body\s+(?<body>.*)"
Output:
body
-------
Scanning server: xxxx
Time: Tue Jun 14 11:01:46 2016
Sender: xxxx
Recipient(s): xxx
Subject: xxx
File(s):xxxx
Other: Attachment: xxxx
GENERATED_ON=Tue Jun 14 11:00:33 CEST 2016
VERSION=xxx
SYSTEM_xxx
SERIAL_NUMxxxx
HOSTNAME\xx
SEQUENCE\xx
PARTNER_SYSTEM_xxx
PARTNER_SERIAL_NUM=xxxx
PARTNER_HOSTNAME\xxx
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
javiergn
Super Champion
06-14-2016
02:26 AM
Let me know if this is what you are looking for:
| stats count | fields - count
| eval _raw = "blah blah blah
MIME-Version = \"1.0\"
mailbox = \"Inbox\"
size = 23156
Message Body
Scanning server: xxxx
Time: Tue Jun 14 11:01:46 2016
Sender: xxxx
Recipient(s): xxx
Subject: xxx
File(s):xxxx
Other: Attachment: xxxx
GENERATED_ON=Tue Jun 14 11:00:33 CEST 2016
VERSION=xxx
SYSTEM_xxx
SERIAL_NUMxxxx
HOSTNAME\xx
SEQUENCE\xx
PARTNER_SYSTEM_xxx
PARTNER_SERIAL_NUM=xxxx
PARTNER_HOSTNAME\xxx
"
| rex field=_raw "(?msi)Message Body\s+(?<body>.*)"
Output:
body
-------
Scanning server: xxxx
Time: Tue Jun 14 11:01:46 2016
Sender: xxxx
Recipient(s): xxx
Subject: xxx
File(s):xxxx
Other: Attachment: xxxx
GENERATED_ON=Tue Jun 14 11:00:33 CEST 2016
VERSION=xxx
SYSTEM_xxx
SERIAL_NUMxxxx
HOSTNAME\xx
SEQUENCE\xx
PARTNER_SYSTEM_xxx
PARTNER_SERIAL_NUM=xxxx
PARTNER_HOSTNAME\xxx
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
arrowecssupport
Communicator
06-14-2016
02:55 AM
Not really, I'm using this to try and extract the email body as i need to see the email headers, but need the body in its own field.
So it would return
Scanning server: xxxx
Time: Tue Jun 14 11:01:46 2016
Sender: xxxx
Recipient(s): xxx
Subject: xxx
File(s):xxxx
Other: Attachment: xxxx
GENERATED_ON=Tue Jun 14 11:00:33 CEST 2016
VERSION=xxx
SYSTEM_xxx
SERIAL_NUMxxxx
HOSTNAME\xx
SEQUENCE\xx
PARTNER_SYSTEM_xxx
PARTNER_SERIAL_NUM=xxxx
PARTNER_HOSTNAME\xxx
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
javiergn
Super Champion
06-14-2016
02:59 AM
Sorry I'm confused. Isn't that what my code above is doing?
The regex will create a new field named body and the content is:
Scanning server: xxxx
Time: Tue Jun 14 11:01:46 2016
Sender: xxxx
Recipient(s): xxx
Subject: xxx
File(s):xxxx
Other: Attachment: xxxx
GENERATED_ON=Tue Jun 14 11:00:33 CEST 2016
VERSION=xxx
SYSTEM_xxx
SERIAL_NUMxxxx
HOSTNAME\xx
SEQUENCE\xx
PARTNER_SYSTEM_xxx
PARTNER_SERIAL_NUM=xxxx
PARTNER_HOSTNAME\xxx
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
arrowecssupport
Communicator
06-14-2016
04:05 AM
Yep I had it all wrong. Thanks for your help.
Get Updates on the Splunk Community!
Exporting Splunk Apps
Join us on Monday, October 21 at 11 am PT | 2 pm ET!With the app export functionality, app developers and ...
Cisco Use Cases, ITSI Best Practices, and More New Articles from Splunk Lantern
Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...
Build Your First SPL2 App!
Watch the recording now!.Do you want to SPL™, too? SPL2, Splunk's next-generation data search and preparation ...
