topic Re: Searching msexchange logs in Splunk Search

Searching msexchange logs

wfarooq124 — Mon, 23 Mar 2020 17:57:10 GMT

is there any splunk query to search for send, recipient and subject in msexchange email logs? I know there is msexchange app but could it be done via simple query, regex? thanks for your help

Re: Searching msexchange logs

to4kawa — Mon, 23 Mar 2020 20:56:52 GMT

what's session field?

Re: Searching msexchange logs

wfarooq124 — Mon, 23 Mar 2020 21:01:06 GMT

@to4kawa thanks for your response I am looking for email sender, recipient and subject fields

Re: Searching msexchange logs

to4kawa — Mon, 23 Mar 2020 21:38:35 GMT

what's the results of searching sender@domain OR subject OR recipient@domain?

Re: Searching msexchange logs

wfarooq124 — Sat, 28 Mar 2020 11:54:45 GMT

@to4kawa this is regarding sourcetype=MSExchange:2013:MessageTracking so basically using it to parse send receive and subject

Re: Searching msexchange logs

to4kawa — Sat, 28 Mar 2020 21:51:07 GMT

https://splunkbase.splunk.com/app/3225/
use add-on.

Re: Searching msexchange logs

3no — Wed, 30 Sep 2020 04:47:15 GMT

You will want to group all your logs by "internal_message_id" or "MID" to do so, you can use the "transaction" command :

 Index=email sourcetype=msexchange | transaction MID

As you'll see transaction is quiet slow, I'll recommand using a groupby instead, It should look something like this :

Index=email sourcetype=msexchange  | stats values(recipient) AS recipient, values(sender) AS sender, values(subject) AS subject by MID

3no