Azure AD B2C | Sign in Activity

Question

Hi,
I want to know if we are able to query for users who have logged in before a certain date ?

Answer 1

Hi @Abhay Chandramouli ,

You can use signinactivity resource type in the Graph API to query the users who have logged in begore a certain date.

https://graph.microsoft.com/beta/users?$$filter=signInActivity/lastSignInDateTime le '2014-01-01T00:00:00Z'  

Supports $filter (eq, ne, not, ge, le) but, not with any other filterable properties. 

Note: Details for this property require an Azure AD Premium P1/P2 license and the AuditLog.Read.All permission. There's a known issue with retrieving this property. This property is not returned for a user who has never signed in or last signed in before April 2020.

Important: APIs under the /beta version in Microsoft Graph are subject to change. Use of these APIs in production applications is not supported.

Reference: https://learn.microsoft.com/en-us/graph/api/resources/user?view=graph-rest-beta#properties
https://learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-beta&tabs=http

If the answer is helpful, please click Accept Answer and kindly upvote it. If you have any further questions about this answer, please click Comment.

Answer 2

This is possible via Microsoft Graph sign-in activity

https://learn.microsoft.com/en-us/graph/api/resources/signinactivity?view=graph-rest-1.0

Audit log permission is needed for this