How to populate a MySQL database with email logs from Exchange Microsoft O365 logs?
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?