Azure Active Directory reporting audit API samples

This article is part of a collection of articles about the Azure Active Directory reporting API.
Azure AD reporting provides you with an API that enables you to access audit data using code or related tools. The scope of this article is to provide you with sample code for the audit API.


For questions, issues or feedback, please contact AAD Reporting Help.


Before you can use the samples in this article, you need to complete the prerequisites to access the Azure AD reporting API.

Known issue

App Auth will not work if your tenant is in the EU region. Please use User Auth for accessing the Audit API as a workaround until we fix the issue.

PowerShell script

# This script will require the Web Application and permissions setup in Azure Active Directory
$clientID       = "<appid>"             # ApplicationId
$clientSecret   = "<key>"         # Should be a ~44 character string insert your info here
$loginURL       = ""
$tenantdomain   = "<domain>"            # For example,
$msgraphEndpoint = ""
$countOfSignInDocsToBeSavedInAFile = 2000

# Get an Oauth 2 access token based on client id, secret and tenant domain
$body       = @{grant_type="client_credentials";resource=$msgraphEndpoint;client_id=$clientID;client_secret=$clientSecret}
$oauth      = Invoke-RestMethod -Method Post -Uri $loginURL/$tenantdomain/oauth2/token?api-version=1.0 -Body $body

if ($oauth.access_token -ne $null) {
    $headerParams = @{'Authorization'="$($oauth.token_type) $($oauth.access_token)"}

    $url = "$msgraphEndpoint/beta/auditLogs/directoryAudits"
    Write-Output "Fetching data using Uri: $url"
        $myReport = (Invoke-WebRequest -UseBasicParsing -Headers $headerParams -Uri $url)
        $jsonReport = ($myReport.Content | ConvertFrom-Json).value
        $fetchedRecordCount = $jsonReport.Count
        $docCount = $docCount + $fetchedRecordCount
        $totalFetchedRecordCount = $totalFetchedRecordCount + $fetchedRecordCount
        Write-Output "Fetched $fetchedRecordCount records and saved into SignIns$i.json"
        if($docCount -le $countOfSignInDocsToBeSavedInAFile)
            $myReport.Content | Out-File -FilePath SignIns$i.json -append  -Force       
            $i = $i+1

        #Get url from next link
        $url = ($myReport.Content | ConvertFrom-Json).'@odata.nextLink'         
    }while($url -ne $null)
    Write-Output "Total Fetched record count is : $totalFetchedRecordCount"

} else {
    Write-Host "ERROR: No Access Token"

Executing the PowerShell script

Once you finish editing the script, run it and verify that the expected data from the Audit logs report is returned.

The script returns output from the audit report in JSON format. It also creates an audit.json file with the same output. You can experiment by modifying the script to return data from other reports, and comment out the output formats that you do not need.

Next steps