This script and report extract all Project Stats (including Boards, Repos, and Pipelines information) within the Azure DevOps organization

Many customers that use Azure DevOps need to identify if projects on your organization are being used. When you navigate a specific project, you have a feature named View project activity, but you have this view only within the project. This report will show this mapping with all the projects in the organization based on the last 30 days' activities.

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

Let’s go understand each command used.


This script and report extract all Team Card Rule Settings (Rule Name, Rule Criteria, and Card Color) within the Azure DevOps organization

Many customers that use Azure DevOps prefer to change Team Card Rule Settings, but when you have different configurations, it’s more complicated to standardized our teams and card colors for that everyone uses these same settings. Thinking about mapping Team Card Rule Settings on Azure DevOps, the following report was created:

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

Let’s go understand each command used.


This script and report extract all Test Plans Configurations and Team Projects within the Azure DevOps organization

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

Let’s go understand each command used.

  • $Organization = Organization URL to list all Projects and respective Test Plans Configurations;
  • $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:


This script and report list all Installed Extensions on the Azure DevOps organization

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

Let’s go understand each command used.

  • $Organization = Organization URL to list all installed extensions on the Azure DevOps organization;
  • $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. Installed…


This script and report extract all teams and iteration capacities on each Team Project in Azure DevOps

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

Let’s go understand each command used.

  • $Organization = Organization URL to list Teams and Iteration Capacities 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:


This script and report extract all Deployment Groups and respective Release Definitions that usage them within the Azure DevOps organization

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

Let’s go understand each command used.

  • $Organization = Organization URL to list all Deployment Groups and respective Release Definitions that usage them;
  • $Connstr = connection string to Azure SQL Database that stores the report information. …


This script and report extract all Task Board Customize Columns within the Azure DevOps organization

Many customers that use Azure DevOps prefer to change Task Board Columns, but when you have different configurations, it’s more complicated to standardized our task boards and verifies that everyone uses these same settings. Thinking about mapping Task Board Columns on Azure DevOps, the following report was created:

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

Let’s go understand each command used.


This script and report extract all Board Columns and Swimlanes on Team Settings within the Azure DevOps organization

Many customers that use Azure DevOps prefer to change Team Settings (Board Columns and Swimlanes), but when you have different configurations, it’s more complicated to standardized our teams and verifies that everyone uses these same settings. Thinking about mapping Configuration Boards on Azure DevOps, the following report was created:

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

Let’s go understand each command used.


This script and report extract all Team Settings (Backlog Levels, Working Days, and Working with Bugs) within the Azure DevOps organization

Many customers that use Azure DevOps prefer to change Team Settings, but when you have different configurations, it’s more complicated to standardized our teams and verifies that everyone uses these same settings. Thinking about mapping Team Settings on Azure DevOps, the following report was created:

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

Let’s go understand each command used.


This script and report extract all Environments and respective Approvals, and Checks 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.

  • $Organization = Organization URL to list all Environments, Approvals, and Checks on Azure DevOps organization;
  • $Connstr = connection string to Azure SQL Database that stores the report information. …

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