how to get lastlogindate of each azure ad users

Shraddha Kurjekar 1

I wanted to know to to get lastlogindate of azure ad users programmatically. How to get lastlogindate...? what should I used to get lastlogindate? different ways to get it?

JamesTran-MSFT 36,461 Reputation points Microsoft Employee

2020-11-26T00:16:54.337+00:00

@Shraddha Kurjekar
I just wanted to check in and see if you had any other questions or if you were able to resolve this issue?

----------

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

1 answer

Alfredo Revilla - Upwork Top Talent | IAM SWE SWA 27,326 Reputation points

2020-11-19T19:57:11.737+00:00

Hello @Shraddha Kurjekar for development (non production) purposes you can use the user signInActivity property. You can get one or more using MS Graph Beta get and list users operations.
For production purposes you can use MS Graph v1.0 List signIns operation and filter by user like this:

GET https://graph.microsoft.com/v1.0/auditLogs/signIns?$filter=userId eq '<user object id>'&$top=1

Let us know if this answer was helpful to you. If so, please remember to accept it so that others in the community with similar questions can more easily find a solution.
Please sign in to rate this answer.
Shraddha Kurjekar 1 Reputation point

2020-11-20T11:18:54.573+00:00

Thank you for response.
I tried with this: GET https://graph.microsoft.com/v1.0/auditLogs/signIns?$filter=userId eq '<user object id>'&$top=1

but not getting 'lastSignInDateTime' property...

Alfredo Revilla - Upwork Top Talent | IAM SWE SWA 27,326 Reputation points

2020-11-20T15:01:53.273+00:00

Hi @Shraddha Kurjekar , look for the createdDateTime property.

Bo Jiang 1 Reputation point

2022-06-20T21:40:24.927+00:00

how to filter out status error when query GET https://graph.microsoft.com/v1.0/auditLogs/signIns?$filter=userId eq '<user object id>'&$top=1

"status": { "errorCode": 50140, "failureReason": "This occurred due to 'Keep me signed in' interrupt when the user was signing in.", "additionalDetails": "This is an expected part of the login flow, where a user is asked if they want to remain signed into this browser to make further logins easier. For more details, see https://techcommunity.microsoft.com/t5/Azure-Active-Directory/The-new-Azure-AD-sign-in-and-Keep-me-signed-in-experiences/td-p/128267" },

Alfredo Revilla - Upwork Top Talent | IAM SWE SWA 27,326 Reputation points

2022-06-21T18:37:30.697+00:00

Hello @Bo Jiang , here:

https://graph.microsoft.com/v1.0/auditLogs/signIns?$filter=userId eq '<USER OID>' and status/errorCode ne 50140&$top=1

Let us know if this answer was helpful to you or if you need additional assistance. If it was helpful, please remember to accept it so that others in the community with similar questions can more easily find a solution.
Sign in to comment