I'm trying to set up a system in Entra ID where I can automatically send email summaries of sign-in logs every month. I want the summary to include details like the number of failed sign-ins, the IP addresses where these attempts are coming from, and the applications being accessed. Ideally, I'd receive an email at the beginning of each month that contains this data for the previous 30 days. I've been advised that I might need to use Power BI and MS Graph, especially since I have an Office E5 license, but I'm not quite sure where to start. Any guidance would be greatly appreciated!
1 Answer
There are multiple ways to automate the email sending and to pull the raw sign-in logs, so you're on the right track. The tricky part will actually be summarizing the raw data. Power BI can definitely help with that, but you could also use Python, PowerShell, or even some third-party tools. Focus on defining exactly what you want in your summary first—that'll help you determine the best tool for the job.
Is connecting the app registration and using the Graph API to link up with Power BI the right approach? Should I just nail down my summarization specifics? Also, how do I go about setting up the emails?