rfennell

param 
(
   $localrepopath = "c:\svn\localrepo",
   $trunkurl = "svn://svnlive.mydomain/application/trunk",
    [string[]]$branches = @(
     "svn://svnlive.mydomain/application/releases/1.0.0",
     "svn://svnlive.mydomain/application/releases/2.0.0"
     )
)

rfennell

name: Workflow Rev Sample

on:
  push:
    branches: [ "main" ]
  pull_request:
    branches: [ "main" ]

# You have to grant the actions read permission else the GH CLI get a 403 error
permissions:

rfennell

param (
  $logfile = "DataMigrationTool.log",
  $tpcUrl = "http://server:8080/tfs/defaultcollectio",
$outputFile = "update-fields.sql"
)
$Errors = @{}
function Get-ItemFromRow {
   param (
   $row,
  $startString,

rfennell

aram (
  $logfile = "DataMigrationTool.log",
  $tpcUrl = "http://server:8080/tfs/defaultcollection",
$witAdminPath = "C:\Program Files\Microsoft Visual Studio\2022\Professional\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer\witadmin.exe",
$outputFile = "update-fields.ps1"
)
$Errors = @{}
function Get-ItemFromRow {
   param (
   $row,

rfennell

import requests
import base64
import os
import argparse

def download_testcases_excel(organization, project, pat, test_case_ids, test_plan_id, test_suite_id,  output_path):
    """
    Download test cases as an Excel file from Azure DevOps Test Plan API.
    """
    api_url = f"https://dev.azure.com/{organization}/{project}/_apis/testplan/TestCases/TestCaseFile?api-version=7.1-preview.1"

rfennell

<#
.SYNOPSIS
    Retrieves pipeline information for all projects in an Azure DevOps organization and exports it to a CSV file.
.DESCRIPTION
    This script connects to an Azure DevOps organization using a Personal Access Token (PAT).
    It enumerates all projects within the organization, retrieves all pipelines for each project,
    and gathers details about each pipeline, including type (YAML or Classic), source repository,
    default branch, repository URL, and the status and time of the latest run.
    The collected information is exported to a specified CSV file.
.PARAMETER organization

rfennell

<#
.SYNOPSIS
    Retrieves Azure DevOps pipeline information and exports it to a CSV file.

.DESCRIPTION
    This script connects to an Azure DevOps organization and project using a Personal Access Token (PAT).
    It fetches all pipelines, gathers details about each pipeline (including type, source repository, branch, and latest run status),
    and exports the collected information to a CSV file.

.PARAMETER organization

rfennell

# A pipeline to update a specific field in a work items that meeting a specific WIQL filter

# Do not trigger on a commit to the repo, but allow a manual run
trigger: none

# Run the pipeline at 1am every day
schedules:
- cron: '1 0 * * *'
  displayName: Daily midnight build
  always: true

rfennell

[CmdletBinding()]
param (
    [Parameter(Mandatory=$true, HelpMessage="The URL of the Azure DevOps organisation e.g. https://dev.azure.com/myorg")]
    $org,
    [Parameter(Mandatory=$true, HelpMessage="The name of the project e.g 'My Project' ")]
    $project,
    [Parameter(Mandatory=$false, HelpMessage="The name of the field to update, defaults to 'Custom.PBIAge'")]
    $fieldName = "Custom.PBIAge",
    [Parameter(Mandatory=$false, HelpMessage="The WIQL query to find the work items to update. This is used if --sharedWiQueryId is not specified")]
    $query = "SELECT [System.Id] FROM workitems WHERE ([System.WorkItemType] = 'Bug' OR [System.WorkItemType] = 'Product Backlog Item' ) AND [System.State] IN ('Active', 'Committed')",

rfennell

# This is the pipeline that runs any scheduled maintainance jobs
# we wish to run in addition to the built in Azure DevOps Maintainance jobs

# The parameters to target each pool and agent
parameters:
  - name: pool
  - name: agent
  - name: nvdapikey

# We cannot use to the parameters directly else we get a 'A template expression is not allowed in this context'