This script and report extract all Task Groups on each Team Project within Azure DevOps

An original script is available on my GitHub repository. See below this script:

Let’s go understand each command used.

  1. PowerShell script will receive the following parameters:
  • $PAT = Personal Access token to connect on Azure DevOps;
  • $Organization = Organization URL to list Task Groups on each project;
  • $Connstr = connection string to Azure SQL Database that stores the report information. To create this report, it’s necessary to create previously a Azure SQL Server and Database and run a script below:

2. Projects List


This script and report extract all Environments and respective Deployments to Multi-Stage Pipeline YAML on each Team Project within Azure DevOps

An original script is available on my GitHub repository. See below this script:

Let’s go understand each command used.

  1. PowerShell script will receive the following parameters:
  • $PAT = Personal Access token to connect on Azure DevOps;
  • $Organization = Organization URL to list Environments and Deployments on each project;
  • $Connstr = connection string to Azure SQL Database that stores the report information. …

This script and report extract all Variables Groups on each Team Project within Azure DevOps

An original script is available on my GitHub repository. See below this script:

Let’s go understand each command used.

  1. PowerShell script will receive the following parameters:
  • $PAT = Personal Access token to connect on Azure DevOps;
  • $Organization = Organization URL to list Variable Groups on each project;
  • $Connstr = connection string to Azure SQL Database that stores the report information. To create this report, it’s necessary to create previously a Azure SQL Server and Database and run a script below:

2. Projects List


This Power BI report list all Service Connections on Team Projects within the Azure DevOps organization

An original report is available on my GitHub repository. This report will list all Service Connections on each Team Project within Azure DevOps.

In this specific report, I’m using OData to connect Azure DevOps. I have access to many tables on this link where I can select different information in Azure DevOps. To connect OData, the link below was used (here was created an Organization parameter):

https://analytics.dev.azure.com/{Organization}/_odata/v4.0-preview


This Power BI report list all users and respective Access Levels within the Azure DevOps organization

An original report is available on my GitHub repository. This report is based on Users interface at Organization Level in Azure DevOps.

  • In this specific report, I’m using Web Data Source to connect Azure DevOps. Here I’ll call REST API that lists all users and respective Access Levels. TO do this, it’s necessary to create Organization parameter):


This Power BI report list Pull Request within the Azure DevOps organization

An original report is available on my GitHub repository. This report is based on an extension Pull Request Manager Hub, created by Carlos Ribeiro, to which I leave my acknowledgment for the great help to create this report.

In this specific report, I’m using OData to connect Azure DevOps. I have access to many tables on this link where I can select different information in Azure DevOps. To connect OData, the link below was used (here was created an Organization parameter):

https://analytics.dev.azure.com/{Organization}/_odata/v4.0-preview


This script and report extract Iteration Path Permissions from user. Before that, it’s necessary to get all groups to which that user belongs.

DISCLAIMER: Due to the number of records generated by this report, two mandatory filters were placed: the name of the user and the name of Team Project. This report was based on the ALM Rangers project Extracting effective permissions from TFS

An original script is available on my GitHub repository. See below this script:

Let’s go understand each command used.

  1. PowerShell script will receive the following parameters:
  • $PAT = Personal Access token to connect on Azure…


This script and report extract Area Path Permissions from user. Before that, it’s necessary to get all groups to which that user belongs.

DISCLAIMER: Due to the number of records generated by this report, two mandatory filters were placed: the name of the user and the name of Team Project. This report was based on the ALM Rangers project Extracting effective permissions from TFS

An original script is available on my GitHub repository. See below this script:

Let’s go understand each command used.

  1. PowerShell script will receive the following parameters:
  • $PAT = Personal Access token to connect on Azure…


This script and report extract Organization Level Permissions from the user. Before that, it’s necessary to get all groups to which that user belongs.

DISCLAIMER: Due to the number of records generated by this report, one mandatory filter was placed: the name of the user. This report was based on the ALM Rangers project Extracting effective permissions from TFS. Within Azure DevOps, click on Organization Settings, after clicking in Permissions, and select a respective group.

An original script is available on my GitHub repository. See below this script:

Let’s go understand each command used.

  1. PowerShell script will receive the…


This script and report extract Project Level Permissions from the user. Before that, it’s necessary to get all groups to which that user belongs.

DISCLAIMER: Due to the number of records generated by this report, two mandatory filters were placed: the name of the user and the name of Team Project. This report was based on the ALM Rangers project Extracting effective permissions from TFS. Within Azure DevOps, to access these same permissions, select a Team Project, click on Project Settings, click in Permissions, and select a respective group.

An original script is available on my GitHub repository. …

Vinicius Moura

DevOps Consultant at N3

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store