To follow along with this tutorial, you will need the following:<\/p>\n\n\n\n
- \n
- An Azure AD tenant<\/li>\n\n\n\n
- Global administrator privileges<\/li>\n\n\n\n
- PowerShell with the Microsoft Graph PowerShell module installed.<\/li>\n<\/ul>\n\n\n\n
Steps to Retrieve the Last Sign-In Date Time for All Users in Azure AD Using Microsoft Graph:\u200b<\/a><\/h3>\n\n\n\n
Step 1: Connect to Microsoft Graph<\/strong>
First, open PowerShell and connect to Microsoft Graph using the following command:<\/p>\n\n\n\nConnect-MgGraph -Scopes Directory.Read.All,AuditLog.Read.All\n<\/code><\/pre>\n\n\n\nStep 2: Export User Data with lastSignInDateTime to CSV<\/strong>
Export the user data based on your requirement either for all users\/member users\/guest users, including the UserPrincipalName and Id, to a CSV file using the following command:<\/p>\n\n\n\nFor all users-<\/p>\n\n\n\n
Get-MgUser -All -Property 'UserPrincipalName','SignInActivity','Mail','DisplayName' | Select-Object @{N='UserPrincipalName';E={$_.UserPrincipalName}}, @{N='DisplayName';E={$_.DisplayName }}, @{N='LastSignInDate';E={$_.SignInActivity.LastSignInDateTime}} | Export-Csv -Path C:\\usernew1.csv -NoTypeInformation -NoClobber\n<\/code><\/pre>\n\n\n\nFor all member users use-<\/p>\n\n\n\n
Get-MgUser -All -Filter \"UserType eq 'Member'\" -Property 'UserPrincipalName','SignInActivity','Mail','DisplayName' | Select-Object @{N='UserPrincipalName';E={$_.UserPrincipalName}}, @{N='DisplayName';E={$_.DisplayName }}, @{N='LastSignInDate';E={$_.SignInActivity.LastSignInDateTime}} | Export-Csv -Path C:\\usernew1.csv -NoTypeInformation -NoClobber\n<\/code><\/pre>\n\n\n\nFor all guest users use-<\/p>\n\n\n\n
Get-MgUser -All -Filter \"UserType eq 'Guest'\" -Property 'UserPrincipalName','SignInActivity','Mail','DisplayName' | Select-Object @{N='UserPrincipalName';E={$_.UserPrincipalName}}, @{N='DisplayName';E={$_.DisplayName }}, @{N='LastSignInDate';E={$_.SignInActivity.LastSignInDateTime}} | Export-Csv -Path C:\\usernew1.csv -NoTypeInformation -NoClobber\n<\/code><\/pre>\n\n\n\nSample Output:<\/p>\n\n\n\n
![\"enter](\"https:\/\/i.stack.imgur.com\/MVQu7.png\")
<\/a><\/figure>\n\n\n\nConclusion:<\/strong>\u200b<\/a><\/h2>\n\n\n\n
In this article, we have explained how to use Microsoft Graph to retrieve the last sign-in date time for all users in Azure AD. By exporting the user data to a CSV file and looping through it to retrieve the last sign-in date time, administrators can easily track user activity and identify any inactive accounts that may need to be disabled or deleted.<\/p>\n\n\n\n
Ref: How to Retrieve the Last Sign-In Date Time for All Users in Azure AD Using Microsoft Graph – Stack Overflow<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Microsoft Graph is a powerful tool that allows administrators to manage their Azure AD tenant and automate tasks. One common task is to retrieve the last sign-in date time for all users in Azure AD. This information can be used to track user activity and identify any inactive accounts that may need to be disabled Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[1249,238,239,10,1224],"tags":[1776,1775],"class_list":["post-5070","post","type-post","status-publish","format-standard","hentry","category-azure-microsoft","category-cloud","category-azure","category-microsoft","category-powershell","tag-aad-user-export-last-sign-in-powershell","tag-how-to-export-last-sign-in-for-all-azure-users-microsoft-graph"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t