Skip to content

Instantly share code, notes, and snippets.

@rfennell
rfennell / DependancyCheckToSonarCloudConvertor.ps1
Last active September 30, 2022 11:46
Script to convert OWASP Dependency Check Results to a format that can be ingested into SonarCloud
param
(
# The OWASP results XML file
$input = "dependancy-results.xml",
# The SonarCloud generic issue JSON file
$output = "dependancy-results.json",
# The file to associate issues with
$filename = "c:\folder\file.cs"
)
@rfennell
rfennell / KeyVaultFilter.yaml
Created February 7, 2023 18:54
An inline task to convert a regex based filter to a comma separated list as required to download Secrets from KeyVault in Azure DevOps
variables:
# the variable used to filter the KeyVault secret list
# This can be a simple prefix and wildcard e.g. 'Config-*''
# Or a more complex regex expression e.g. ^(?:Config-*|Settings-*)
- name: KV-Filter
value: '^(?:Config-*|Settings-*)'
# the variable used to KeyVault name
- name: KV-Name
value: 'bm-kv1'
@rfennell
rfennell / Set-Azure DevOpsBrnachPolicies.ps1
Created November 12, 2021 12:40
Set Azure DevOps All Repositories Branch policies
param
(
[parameter(Mandatory=$true,HelpMessage="The target Azure DevOps Instance")]
$org,
[parameter(Mandatory=$true,HelpMessage="The new project name")]
$projectName,
[parameter(Mandatory=$true,HelpMessage="A PAT with access to target org")]
$pat
@rfennell
rfennell / Get-NugetPackage.ps1
Last active April 1, 2023 15:39
Downloading NuGet packages with 'System.Net.WebClient' from an Azure DevOps Artifact feed
param(
$package,
$version,
$azdoOrg,
$feedname,
# provide a, Azure DevOps PAT if it a private feed
$pat,
$DestinationPath = "$package-$version.zip"
)
@rfennell
rfennell / run.csx
Created July 14, 2023 12:24
Azure Function code to send a Tweet to the V2 Twitter API using OAUTH1.0
#r "Newtonsoft.Json"
using System.Text;
using System.Net;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Primitives;
using Newtonsoft.Json;
using OAuth;
public static async Task<IActionResult> Run(HttpRequest req, ILogger log)
@rfennell
rfennell / Remove-DeletedGitBranches.ps1
Last active July 29, 2023 10:08
A PowerShell script to do a git fetch with a prune then also delete any local branches of the same name
# To set as Git Alias
# git config --global alias.tidy "!pwsh -command C:\MyFolder\Remove-DeletedGitBranches.ps1"
param
(
[Parameter()]
[Switch]
$Force
)
Write-Host "Getting list of branches"
@rfennell
rfennell / export-tfs-upgate-log-to-csv.ps1
Last active October 5, 2023 10:44
Extracts the timestamps from a TFS/Azure DevOps upgrade log or ease of charting
param
(
$logfile = "TPC\_ApplyPatch.log",
$outfile = "out.csv"
)
# A function to covert the start and end times to a number of minutes
# Can't use simple timespan as we only have the time portion not the whole datetime
# Hence the hacky added a day-1 second
@rfennell
rfennell / DockerCompose.yml
Last active November 23, 2023 09:10
A BICEP file to deploy Snipe IT to Azure - see the comments below for usage details
version: "3"
services:
snipe-it:
image: snipe/snipe-it:latest
volumes:
- snipeit:/var/lib/snipeit
- snipeit-logs:/var/www/html/storage/logs
volumes:
@rfennell
rfennell / AZDO-StageDependencyVariables.yml
Last active January 29, 2024 18:59
Azure DevOps Pipelines Stage Dependency Variables Usage Demo
parameters:
- name: Value
type: boolean
default: true
pool:
vmImage: ubuntu-latest
stages:
@rfennell
rfennell / CommitToThisRepo.ps1
Created January 19, 2018 19:36
PowerShell script add a commit to the current repo for use inside a VSTS CI/CD process
(
$file = "readme.md",
$text = "Automated edit",
$wi = "#13 #14"
)
"Set config"
git config --global user.email "builduser@dummy.local" # any values will do, if missing commit will fail
git config --global user.name "Build user"