How to populate a MySQL database with email logs from Exchange Microsoft O365 logs?

Joad-5499 0 Reputation points
2023-11-14T17:09:16.53+00:00

I have a MySQL database in Azure. I'd like to add some tables such as EmailOutreach with some columns such as: EmailUniqueID | Sender | To Recipients (comma delimit) [or may be one row per each recipient] | DeliveryStatus [bounced, etc.] | RecipientDomain | SenderDomain | Email Subject | Date/Time Sent [Probably some others]

To populate this data, I'd like to get the information from my Exchange Microsoft O365 data. Looking at this documentation: https://learn.microsoft.com/en-us/exchange/monitoring/monitoring I think I can utilize the email logs to get this data. I did find this post of someone utilizing PowerShell to do so: https://community.spiceworks.com/topic/2219220-automated-export-email-logs

What is the best approach for getting email logs from Exchange Microsoft O365 and populating them into MySQL using Azure?

Exchange Online
Exchange Online
A Microsoft email and calendaring hosted service.
6,178 questions
Exchange | Exchange Server | Development
Exchange | Exchange Server | Management
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.