Back to script library
Entra / Microsoft 365 · Compliance & audit

Report audit recs user sign ins

Search the unified audit log for user sign-in and Teams session start events.

Connect & set up

Run these once per session. All scopes are read-only unless the script makes changes.

Connect-ExchangeOnline -SkipLoadingCmdletHelp

Run it

The main script. Copy it, or download the .ps1 and run it from your console.

param(
[int] $LookbackDays = 90
)
$Modules = Get-Module | Select-Object -ExpandProperty Name
If ("ExchangeOnlineManagement" -notin $Modules) {
Write-Host "Loading Exchange Online Management module"
Connect-ExchangeOnline -SkipLoadingCmdletHelp
}
[array]$Records = (Search-UnifiedAuditLog -StartDate (Get-Date).AddDays(-$LookbackDays) -EndDate (Get-Date).AddDays(+1) -Operations UserLoggedIn, TeamsSessionStarted -SessionCommand ReturnLargeSet -ResultSize 5000 -Formatted)
If ($Records.Count -eq 0) {
Write-Host "No Audit records found for user logons."
Break
}
# Remove any duplicates
$Records = $Records | Sort-Object Identity -Unique | Sort-Object { $_.CreationDate -as [datetime]} -Descending
Write-Host ("Processing {0} audit records..." -f $Records.count)
$Report = [System.Collections.Generic.List[Object]]::new()
ForEach ($Rec in $Records) {
$AuditData = ConvertFrom-Json $Rec.Auditdata
If ($AuditData.Workload -eq "MicrosoftTeams") {
$Client = $Auditdata.ObjectId
$Status = "Succeeded"
} Else {
$Client = $AuditData.ExtendedProperties[0].Value
$Status = $AuditData.ResultStatus
}
$ReportLine = [PSCustomObject]@{
TimeStamp = $Rec.CreationDate
User = $AuditData.UserId
Action = $AuditData.Operation
Client = $Client
IpAddress = $AuditData.ActorIpAddress
Status = $Status
Workload = $AuditData.Workload
}
$Report.Add($ReportLine)
}
$Report | Out-GridView

Parameters

ParameterDefaultNotes
-LookbackDays90Number of days back to search the unified audit log.
Attribution