# 设置 Azure DevOps 组织和项目名称
$orgName = "<org-name>"
$projectName = "<project-name>"
# 设置 Azure DevOps 发布管道 ID 和阶段名称
$pipelineId = <pipeline-id>
$stageNames = @("<stage-name-1>", "<stage-name-2>", "<stage-name-3>")
# 设置 Azure DevOps PAT 和基本 URL
$pat = "<personal-access-token>"
$baseUrl = "https://dev.azure.com/$orgName/$projectName"
# 设置查询的日期范围
$startDate = (Get-Date).AddDays(-14).ToString("yyyy-MM-ddTHH:mm:ssZ")
$endDate = (Get-Date).ToString("yyyy-MM-ddTHH:mm:ssZ")
# 创建 Azure DevOps REST API 查询以检索部署结果
$queryUrl = "$baseUrl/_apis/release/deployments?definitionId=$pipelineId&$top=100&$expand=All&$filter=deploymentStatus eq 'succeeded' or deploymentStatus eq 'failed' and startedTime ge $startDate and startedTime le $endDate"
$headers = @{Authorization = "Bearer $pat"}
$response = Invoke-RestMethod -Uri $queryUrl -Headers $headers -Method Get
# 创建一个新的 Excel 工作簿和工作表
$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Add()
$worksheet = $workbook.Worksheets.Add()
# 将部署结果写入 Excel 工作表
$row = 1
$col = 1
$worksheet.Cells.Item($row, $col) = "阶段"
$worksheet.Cells.Item($row, $col+1) = "成功计数"
$worksheet.Cells.Item($row, $col+2) = "失败计数"
$row++
foreach ($stageName in $stageNames) {
    $stageDeployments = $response.value | Where-Object {$_.releaseEnvironment.name -eq $stageName}
    $successfulCount = ($stageDeployments | Where-Object {$_.deploymentStatus -eq "succeeded"}).Count
    $failedCount = ($stageDeployments | Where-Object {$_.deploymentStatus -eq "failed"}).Count
    $worksheet.Cells.Item($row, $col) = $stageName
    $worksheet.Cells.Item($row, $col+1) = $successfulCount
    $worksheet.Cells.Item($row, $col+2) = $failedCount
    $row++
}
# 保存 Excel 工作簿并关闭 Excel 应用程序
$workbook.SaveAs("DeploymentResults.xlsx")
$excel.Quit()

# 定义组织、项目和发布定义 ID 的变量
$organization = "<org name>"
$project = "<project name>"
$releaseDefinitionId = "<release definition ID>"
# 使用个人访问令牌 (PAT) 进行 Azure DevOps 鉴权
$personalAccessToken = "<PAT>"
$base64AuthInfo = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(":$($personalAccessToken)"))
$headers = @{Authorization = "Basic $base64AuthInfo"}
# 通过 ID 获取发布定义
$releaseDefinitionUrl = "https://vsrm.dev.azure.com/$($organization)/$($project)/_apis/release/definitions/$($releaseDefinitionId)?api-version=6.0"
$releaseDefinition = Invoke-RestMethod -Uri $releaseDefinitionUrl -Headers $headers -Method Get
# 从发布定义中获取阶段名称
$stageNames = $releaseDefinition.environments.name
# 输出阶段名称
Write-Host "阶段名称:"
$stageNames

<details>
<summary>英文:</summary>
I am able to get the stage names of a release defination/pipeline, but still unable to write the succcessful and failed count of deployments from each stage for a week data onto excel sheet.