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://video2.skills-academy.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?

Microsoft Exchange Online
Exchange Server Development
Exchange Server Development
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Development: The process of researching, productizing, and refining new or existing technologies.
525 questions
Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
7,465 questions