Get-AzureADAuditSignInLogs returning $null in Automation Accounts

Question

I have a simple script to get the last sign in details for each user in Azure. When running the script from Visual Studio, it all runs fine with no errors. After uploading the script to an Azure Automation Account, I am getting the error "Object reference not set to an instance of an object".

I have checked and the command 'Get-AzureADAuditSigninLogs' is returning $null

$users = Get-AzureADUser -All $true
foreach ( $user in $users ) {
    $userLogs = Get-AzureADAuditSigninLogs -Filter "startsWith(userPrincipalName, '$( $user.UserPrincipalName )')" -All $true
}

Any ideas on the issue that could be causing this to occur in the Automation account but not visual studio?

Answer 1

As per this issue,-All $true parameter is not working for cmdlet Get-AzureADAuditSignInLogs as expected.

To resolve it, you can try upgrading to AzureADPreview v2.0.2.89.

Alternatively, you can also try as suggested by psignoret:

Format string with -f or [String]::Format():

Write-Host ("startsWith(userPrincipalName ,'{0}')" -f $user.userPrincipalName)

Write-Host [String]::Format("startsWith(userPrincipalName ,'{0}')", $user.userPrincipalName)