ado-analytics

Project Overview

This project provides multiple ways to fetch and analyze Azure DevOps Work Item data using Python, C#, Terraform, and OData queries. It is organized for clarity and ease of extension.

Structure

• python/ — Python scripts and requirements
• csharp/ — C# scripts
• terraform/ — Terraform infrastructure as code
• main.odata — Example OData query
• .env.example — Sample environment variables

Quick Start

1. Python

cd python
python main.py

Install dependencies

pip install -r requirements.txt

2. C#

cd csharp
csc main.cs
main.exe

3. Terraform

cd terraform
terraform init
terraform apply

4. OData Query

Open main.odata in VSCode with the vscode-odata extension and run/modify as needed.

Environment Variables

Copy .env.example to .env and fill in your values:

AZURE_DEVOPS_PERSONAL_ACCESS_TOKEN=your_token
AZURE_DEVOPS_ORGANIZATION_URL=https://dev.azure.com/your_org
AZURE_DEVOPS_PROJECT_NAME=your_project
AZURE_DEVOPS_TEAM_NAME=your_team
AZURE_DEVOPS_WORK_ITEM_TYPE=Bug
AZURE_DEVOPS_WORK_ITEM_STATE=Active
AZURE_DEVOPS_WORK_ITEM_AREA_PATH=your_area_path
AZURE_DEVOPS_WORK_ITEM_ITERATION_PATH=your_iteration_path
AZURE_DEVOPS_ANALYTICS_URL=https://analytics.dev.azure.com
AZURE_DEVOPS_ORGANIZATION=your_org

Developer Notes

• Each language is in its own folder for clarity.
• Add new scripts or modules in the appropriate folder.
• See instructions.md for more details and tips.

Resources

Azure DevOps & Analytics

• Azure DevOps Work Item REST API
• Azure DevOps Work Item OData REST API
• Azure DevOps Analytics Quick Reference
• Azure DevOps Analytics Data Model
• Grant Permissions to use Azure DevOps Analytics

Terraform

• Terraform Tutorial for Azure

Management Reports & Community

• Management Reports in Azure DevOps (Video)
• Management Reports in Azure DevOps (GitHub repo)
• Vinicius Moura Blog

SDKs & Extensions

• Azure DevOps Python SDK

Credits

Dot ENV. As I searched for a package to read the .env file, I found this article and thought it was a good idea to use the approach. Simple. No need to install any package. Also, makes complete sense. Dusted