All Apps and Add-ons

Want to pull a report from Outlook emails filtered based on subject line by running query in splunk

iqbalintouch
Path Finder

Hi,
I want to pull a report which reads a specific subject line from outlook emails and tells me that how many times I have received the same email and on which dates particularly.

i.e: if the email subject line says, "My Alert: ecom sale low volume Alert" , I need to pull a report for this alert and when this alert was received in last 1 year and how many times.
so the report should contain 3 columns, subject_line - received date - frequency/counts of this email

0 Karma

iqbalintouch
Path Finder

Hi DavidHourani,

Thank you for the response but this doesn't helped.

We don't have this index and sourcetype. What I am looking for a report from Microsoft outlook using their API and by running query in splunk.

Regards,
Iqbal

0 Karma

DavidHourani
Super Champion

Hi @iqbalintouch,

Your search here from what you're explaining seems quite straightforward :

index=office365 sourcetype=email | stats count, list(received_date) as received_dates, last(received_date) as last_seen by subject

Let me know if anything is missing and we can work on that.

Cheers,
David

DavidHourani
Super Champion

Hi @iqbalintouch,

If you're looking for a way to connect then you will need to use this app :

https://splunkbase.splunk.com/app/4055/
Documentation here :
https://docs.splunk.com/Documentation/AddOns/released/MSCloudServices/Configureinputs

0 Karma
Get Updates on the Splunk Community!

Register to Attend BSides SPL 2022 - It's all Happening October 18!

Join like-minded individuals for technical sessions on everything Splunk!  This is a community-led and run ...

What's New in Splunk Cloud Platform 9.0.2208?!

Howdy!  We are happy to share the newest updates in Splunk Cloud Platform 9.0.2208! Analysts can benefit ...

Admin Console: A Single, Unified Interface for All Your Cloud Admin Needs

WATCH NOWJoin us to learn how the admin console can save you time and give you more control over the Splunk® ...