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 NameIf ("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]} -DescendingWrite-Host ("Processing {0} audit records..." -f $Records.count)$Report = [System.Collections.Generic.List[Object]]::new()ForEach ($Rec in $Records) {$AuditData = ConvertFrom-Json $Rec.AuditdataIf ($AuditData.Workload -eq "MicrosoftTeams") {$Client = $Auditdata.ObjectId$Status = "Succeeded"} Else {$Client = $AuditData.ExtendedProperties[0].Value$Status = $AuditData.ResultStatus}$ReportLine = [PSCustomObject]@{TimeStamp = $Rec.CreationDateUser = $AuditData.UserIdAction = $AuditData.OperationClient = $ClientIpAddress = $AuditData.ActorIpAddressStatus = $StatusWorkload = $AuditData.Workload}$Report.Add($ReportLine)}$Report | Out-GridView
Parameters
ParameterDefaultNotes
-LookbackDays90Number of days back to search the unified audit log.Attribution
Author
Office365itpros