Using PowerShell for Microsoft graphs to view the SignInActivity and SignInSessionsValidFromDateTime data?

Question

How can I view the SignInActivity and SignInSessionsValidFromDateTime?

Because with the below PowerShell command,

Get-MgUser -Filter "signInActivity/lastSignInDateTime le $([datetime]::UtcNow.AddDays(-90).ToString("s"))Z" -All:$true -Property *| Select-Object SignInActivity, SignInSessionsValidFromDateTime

The result is empty like below:

I can't figure out how to get the information. Is there another way to view this data? Or maybe some other command I can use to access it?

Thanks in advance.

Answer 1

Hi @EnterpriseArchitect ,

Thanks for reaching out.

To get the signIn activity and SignInSessionsValidFromDateTime properties of a user, you need to have the

AuditLog.Read.All and Directory.Read.All permissions.

You can try the following PowerShell command to view the SignInActivity and SignInSessionsValidFromDateTime properties of a user:

Import-Module Microsoft.Graph.Users
Connect-MgGraph -Scopes "AuditLog.Read.All","Directory.Read.All"
Get-MgUser | Select-Object UserPrincipalName, SignInActivity,SignInSessionsValidFromDateTime | Export-csv "$((Get-Date -format FileDateTimeUniversal).toString())_signin.csv"

The above command will export the xml file with below details:

Hope this will help.

Thanks,

Shweta

---

Please remember to "Accept Answer" if answer helped you.