Skip to content

jofried/AzureAD_LastSignInTimeReport

Repository files navigation

AzureAD_LastSignInTimeReport

Using an Azure AD App Registration and the Microsoft Graph API, we can pull the signInActivity of users and extract the value of "lastSignInDateTime". This would allow you to find users who have not signed into their account for a while, and you could determine whether or not the account/user is still active or not.

You will first need to complete the steps to create the Azure AD app registration. These steps are outlined in the PDF Create App Registration for Microsoft Graph.pdf.

After the App Registration is configured, you will need to update the Powershell script with the AppID, TenantID, and Client_Secret. These variables are defined in the first few lines of the script

The script will output the results to a CSV file. The CSV file will be saved under the "C:\temp" directory, please make sure this filepath exists. The CSV file can be opened in Excel to sort and filter the results to find users that have not logged in since a given time.

About

Using an Azure AD App Registration and the Microsoft Graph API, we can pull the signInActivity of users and extract the value of "lastSignInDateTime". This would allow you to find users who have not signed into their account for a while, and you could determine whether or not the account/user is still active or not.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors