Unable to query signinactivity for individual user

Question

I would like to include signInActivity for an individual user when querying the graph API. I am able to get this information by calling https://graph.microsoft.com/v1.0/users?$select=signInActivity, however, if I try to get the data for a singular user by calling https://graph.microsoft.com/v1.0/users/{UPN}?$select=signInActivity I get a 400 error.

Is this expected behavior? Is sign-in activity only available when querying all users?

Answer 1

Hello Brendan,

Thanks for reaching out. Selecting the 'signInActivity' resource using UPN is not supported. You need to use the GUID of the user, for example https://graph.microsoft.com/v1.0/users/[GUID]?$select=signInActivity

Alternatively using you can use the 'auditLogs' endpoint to get user signin info by UPN as below:

https://graph.microsoft.com/v1.0/auditLogs/signIns?$filter=userPrincipalName eq 'UPN'

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

Thanks.

Answer 2

Hello Brendan,

Good Day. Hope all is well.

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

Thanks