Hi Jiajun,

I appreciate your support. The issue was definitely the repository name. The difference was the uppercase letters I used for the server name in the ServerName parameter. I assumed it wasn’t case‑sensitive like the Export-AuditReport.ps1 script, but when I checked the URL string used in the Audit Trail tool, the datasource parameter was in lowercase. I copied it exactly as shown, and the report worked.

Thank you for your support!

In case someone needs it, and hoping I’m not overstepping, I added two modifications to your script, which I’m copying below, so we can set the desired date ranges as well as specify a user to audit. I hope this helps others — it worked for me. Any modifications I made are marked with the comment “Mario Grau”.

To call the additional parameters:

.\Update-ReportStartEndDays.ps1 -Repository repositoryname(servername)" -ReportId "ABCD1234EFGH-IJKLM" -LFStartDate 2026-04-18 -LFEndDate 2026-04-19 -userFilter "Domain\Username"

The modified script:

# Copyright (c) Laserfiche.

param(
  [Parameter(Mandatory=$true)]
  [string] $Repository,
  [Parameter(Mandatory=$true)]
  [string] $ReportId,
  [Parameter(Mandatory=$false)]
  # N E W   P A R A M E T E R S (Mario Grau)
  [datetime] $LFStartDate,
  [Parameter(Mandatory=$false)]
  [datetime] $LFEndDate,
  [Parameter(Mandatory=$false)]
  [string] $userFilter = "Everyone",
  # End - N E W   P A R A M E T E R S (Mario Grau)
  [string] $Username,
  [SecureString] $Password,
  [string] $BaseUrl = "http://localhost/AuditTrail"
)

if(-not $BaseUrl.EndsWith("/"))
{
    $BaseUrl = "$BaseUrl/"
}

if (-not [string]::IsNullOrEmpty($Username))
{
    $credential = New-Object System.Management.Automation.PSCredential($Username, $Password)
}

if ($credential -eq $null)
{
    $savedReportResponse = Invoke-WebRequest "$($BaseUrl)api/SavedReport/Get?reportId=$($ReportId)&dataSource=$($Repository)&isDraft=false" -UseDefaultCredentials #-AllowUnencryptedAuthentication    #$savedReportResponse
}
else
{
    $savedReportResponse = Invoke-WebRequest "$($BaseUrl)api/SavedReport/Get?reportId=$($ReportId)&dataSource=$($Repository)&isDraft=false" -Credential $credential
}

# ************************************************************
# N E W   P A R A M E T E R S (Mario Grau)
# ************************************************************
# If not Start Date is defined, use the day before the current date 
if ($LFStartDate -eq $null)
{   $startDate = (Get-Date).AddDays(-1).ToString("yyyy-MM-dd")
}
else
{
    $startDate = $LFStartDate.ToString("yyyy-MM-dd")
}

# If not End Date is defined, use the current date 
if ($LFStartDate -eq $null)
{   $endDate = (Get-Date).ToString("yyyy-MM-dd")
}
else
{
    $endDate = $LFEndDate.ToString("yyyy-MM-dd")
}
# ************************************************************

$timeFilter = @{
      "colDisplayName"="Event time";
      "colId"="eventTime";
      "predDisplayName"="by date";
      "predId"="IN_DATE_RANGE";
      "nodeID"=0;
      "fieldType"= "DATETIME";
      "dateRange"= @{
        "rangeType"= "RANGE";
        "startTimeObj"= @{
          "datetime"= (Get-Date -Date $startDate).ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.000Z");
          "isDateValid"= $true;
          "isTimeValid"= $false;
          "utcDateString"= (Get-Date -Date $startDate).ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.000Z")
        };
        "endTimeObj"= @{
          "datetime"= (Get-Date -Date $endDate).ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.000Z");
          "isDateValid"= $true;
          "isTimeValid"= $false;
          "utcDateString"= (Get-Date -Date $endDate).ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.000Z")
        };
        "ageInDays"=7
      };
      "escape"= $false
    }

$savedReport = $savedReportResponse.Content | ConvertFrom-Json

# Remove any existing User filter (Mario Grau)
$otherPreFilters = $savedReport.preFilters | Where {$_.colId -ne "eventTime" -and $_.colId -ne "user.userName"}
if ($otherPreFilters -ne $null)
{
    $savedReport.preFilters = $otherPreFilters,$timeFilter
}
else
{
    $savedReport.preFilters[0] = $timeFilter
}

# ************************************************************
# N E W   P A R A M E T E R S  -  U S E R (Mario Grau)
# ************************************************************
# If User audit is defined
if ($userFilter -ne "Everyone")
{   Write-Output "userFilter:" $userFilter
    $userParameter = @{
        "colDisplayName"="Name";
        "colId"="user.userName";
        "predDisplayName"="is equal to";
        "predId"="EQUAL_TO_STRING";
        "nodeID"=0;
        "fieldType"= "STRING";
        "value"=$userFilter;
        "escape"= $false
    }

    $otherPreFilters = $savedReport.preFilters | Where {$_.colId -ne "user.userName"}
    if ($otherPreFilters -ne $null)
    {
        $savedReport.preFilters = $otherPreFilters,$userParameter
    }
    else
    {
        $savedReport.preFilters[0] = $userParameter
    }
    # To see the JSON content 
    # $savedReport | Out-File "C:\Users\$env:USERNAME\Documents\Audit Reports\ReportResponseJSON.txt"
}
# ************************************************************


if ($credential -eq $null)
{
    Invoke-WebRequest -Method POST "$($BaseUrl)api/SavedReport/Post?reportName=$($savedReport.reportName)&reportId=$($ReportId)&shared=true&force=true&dataSource=$($Repository)" -body $($savedReport | ConvertTo-Json -Depth 20) -UseDefaultCredentials -ContentType "application/json" 

}
else
{
    Invoke-WebRequest -Method POST "$($BaseUrl)api/SavedReport/Post?reportName=$($savedReport.reportName)&reportId=$($ReportId)&shared=true&force=true&dataSource=$($Repository)" -body $($savedReport | ConvertTo-Json -Depth 20) -Credential $credential -ContentType "application/json" 
}