As a Cloud Engineer, I’m always looking for ways to automate processes and streamline the management of our Azure environment. Recently, a customer approached me with a challenge: they needed to extract the last sign-in date for every user in their tenant. Although the Entra ID portal provides this information, the customer required it in a CSV format so that their security team could review the data, collaborate with user managers, and determine if certain accounts were still needed.
The Challenge
The customer needed a consolidated CSV report that contained each user’s:
- Display Name
- User Principal Name
- Email Address
- Last Sign-In Date
- Manager Information (which includes the manager’s display name and email)
Although the Entra ID portal displays sign-in data, it has its limitations:
Data Extraction vs. Portal View
While the Entra ID portal provides sign-in data, having it in CSV format enables deeper analysis and easier sharing among teams. This approach consolidates all the required information into one single report. Currently, the portal doesn’t allow you to add a manager column in the view, meaning that extracting manager details would otherwise be an extremely manual process.
Get Practical 