loop backwards through current month
I have a script to pull audit logs from the O365 compliance centre. I'd like to use the script in a loop that I can run at the end of the month, executing once for each day until the 1st is reached. #Connect to Exchange Online Connect-ExchangeOnline -ShowBanner:$False $StartRemove = -1 $EndRemove = $StartRemove+1 #Set Date Filters - past 24 hours $StartDate = ((Get-Date).Date).AddDays($StartRemove) $EndDate = (Get-Date).Date.AddDays($EndRemove) #Filter Audit log to Find specific operations $SiteURLs = @("https://company.sharepoint.com/") $Date = ((Get-Date).Date).AddDays(-1) -Format "yyyy-MM-dd" $CSVFile = "C:\Temp\"+$Date+".csv" $FileAccessOperations = @('PageViewed') $SharePointLog = Search-UnifiedAuditLog -StartDate $StartDate -EndDate $EndDate -Operations $FileAccessOperations -ResultSize 5000 -ObjectIds $SiteURLs $AuditLogResults = $SharePointLog.AuditData | ConvertFrom-Json | Select CreationTime,UserId,Operation, ObjectID,SiteUrl,SourceFileName,ClientIP #Export Audit log results to CSV $AuditLogResults $AuditLogResults | Export-csv -Path $CSVFile -NoTypeInformation #Disconnect Exchange Online Disconnect-ExchangeOnline I image it will look something like this for ($EndDate = (Get-Date).Date; $EndDate -eq "01 November 2023 00:00:00"; (Get-Date).Date.AddDays(-1)) { Write-Host The value of Var is: $EndDate }