Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Gets the timeline of given build definition Ids for a project and exports them into a CSV file.
#In this script I expect that the user is already logged in into Azure DevOps with the VSTeam module
$projectName = "Pipeline Artifacts vs Build Artifacts"
$buildDefinitionIds = @(15,16,17,19)
$csvStatsFilePath = "C:\temp\BuildStats.csv"
#function to convert the flat timeline logs to a parent child tree, since the timeline has
#pipeline, phases and tasks which follow a hierarchy
Function ConvertTo-TreeArray($flatArray,$parentKey,$childKey){
$groupedByDefinition = $flatArray | Group-Object -Property $parentKey
foreach($flatObj in $flatArray){
$children = $groupedByDefinition | Where-Object {
$_.Name -eq $flatObj.$childKey
if($null -ne $children){
$children = $children | Sort-Object order
Add-Member -InputObject $flatObj -MemberType NoteProperty -Name Children -Value $children.Group
return $flatArray | Where-Object { $ -eq "__default"}
# Get Build Stats
$builds = Get-VSTeamBuild -ProjectName $projectName -StatusFilter completed -Definitions $buildDefinitionIds | Sort-Object -Property queueTime,definitionName
$InformationPreference = "continue"
$ErrorActionPreference = "stop"
$buildTimelines = @()
foreach($build in $builds){
Write-Information -MessageData "Checking build $($build.buildNumber) for definition $($build.definitionName)"
$url = "$($build._links.timeline.href)?api-version=5.1-preview.2"
$json = Invoke-RestMethod -Method Get -Uri $url
$buildTimeline = $json.records
$selectedTimeline = $buildTimeline #| Select-Object -Property id,parentId,type,Name,startTime,finishTime,order
#$selectedTimeline | Out-GridView
$treeArray = ConvertTo-TreeArray -flatArray $selectedTimeline -parentKey "parentId" -childKey "Id"
Add-Member -InputObject $treeArray -MemberType NoteProperty -Name BuildName -Value $build.definitionName
Add-Member -InputObject $treeArray -MemberType NoteProperty -Name BuildNumber -Value $build.buildNumber
Add-Member -InputObject $treeArray -MemberType NoteProperty -Name BuildId -Value $
$buildTimelines = $buildTimelines + $treeArray
# build the csv to be exported
$exportedBuildStats = @()
foreach($timeline in $buildTimelines){
$exportStatInfo = @{}
foreach($phase in $timeline.Children){
if($null -eq $phase.children){
$job = $phase.Children[0]
foreach($task in $job.Children){
[datetime]$endTimeDt = [datetime]$task.finishTime
[datetime]$startTimeDt = [datetime]$task.startTime
#rounding time to milliseconds by deducting it's ticks down to the current second
$endTimeDt = $endTimeDt.Ticks - ($endTimeDt.Ticks % [TimeSpan]::TicksPerSecond)
$startTimeDt = $startTimeDt.Ticks - ($startTimeDt.Ticks % [TimeSpan]::TicksPerSecond)
$exportStatInfo = [ordered] @{
"BuildName" = $timeline.BuildName
"BuildNumber" = $timeline.BuildNumber
"BuildId" = $timeline.BuildId
"Phase" = $
"TaskName" = $
"TaskStartTime" = $startTimeDt
"TaskFinishTime" = $endTimeDt
"TaskOrder" = $task.order
"TaskRuntimeSpan" = $endTimeDt - $startTimeDt
"TaskResult" = $task.result
$exportStat = New-Object -TypeName PSObject -Property $exportStatInfo
$exportedBuildStats = $exportedBuildStats + $exportStat
#$exportedBuildStats | Out-GridView
$exportedBuildStats | ConvertTo-Csv -Delimiter ";" -NoTypeInformation | Out-File -FilePath $csvStatsFilePath -Encoding utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.