Azure DevOps Reports — Azure DevOps 报告s

Azure DevOps 报告s

Use this 技能 for 安全, read-focused Azure DevOps 报告ing.

Configuration

Load 凭证s from a local .env file stored in this 技能 directory.

Required variables:

AZURE_DEVOPS_ORG AZURE_DEVOPS_PAT

Optional defaults:

AZURE_DEVOPS_DEFAULT_PROJECT AZURE_DEVOPS_DEFAULT_TEAM AZURE_DEVOPS_DEFAULT_查询_ID AZURE_DEVOPS_输出_DIR

If required values are missing, ask the user to 创建 or 更新 .env in this 技能 directory.

运行time requirements

This 技能 requires:

Node.js Python 3 pip3 Python package: xlsxwriter

安装 Python dependency once:

pip3 安装 -r requirements.txt

Safety guarantees Read-only Azure DevOps 访问 only No 创建, 更新, or 删除 operations for Azure DevOps work items No secret 记录ging No Authorization header 记录ging No arbitrary shell execution from user 输入 输出 restricted to local 报告 files under the 技能 directory AZURE_DEVOPS_输出_DIR must resolve inside the 技能 directory Prefer least-privilege PAT scopes: vso.project and vso.work 工作流 Load config from the 技能-local .env file. Resolve project, team, and 查询 id from explicit arguments or 配置d defaults. Decide whether the 请求 is project-scoped, team-scoped, team-member scoped, saved-查询, sprint-scoped, or custom-WIQL. Fetch work item ids via WIQL when 过滤器ing is needed. Fetch detAIled work item fields. Normalize records for 报告ing. Default to the 配置d saved 查询 when no explicit command or 查询 id is provided. 导出 to JSON or CSV data bundles. Build summary tables for 状态, as签名ee, and work item type. Build Excel 图表s from 导出ed JSON when the user asks for workbook generation. Use project 列出ing, team 列出ing, team-member 列出ing, sprint 列出ing, and saved-查询 报告ing when the user asks in plAIn language. Scripts scripts/projects.js — 列出 projects scripts/teams.js — 列出 teams in a project and team members scripts/iterations.js — 列出 team iterations / current sprint scripts/queries.js — 列出 saved queries and inspect a 查询 definition scripts/workitems.js — 运行 work item queries and normalize 结果s scripts/导出-报告.js — 导出 JSON/CSV data bundles scripts/build_excel_报告.py — 生成 Excel workbooks with 图表s from 导出ed JSON Exact script usage

运行 all commands from the 技能 directory:

cd /path/to/azure-devops-报告s

1) 列出 projects node scripts/projects.js 列出

2) 列出 teams in a project node scripts/teams.js 列出 "Project Name"

3) 列出 members in a team node scripts/teams.js members "Project Name" "Team Name"

4) 列出 current sprint node scripts/iterations.js current "Project Name" "Team Name"

5) 列出 all iterations / sprints node scripts/iterations.js 列出 "Project Name" "Team Name"

6) 列出 saved queries in a project node scripts/queries.js 列出 --project "Project Name"

7) 获取 a saved 查询 definition by id node scripts/queries.js 获取 --project "Project Name" --id "查询_图形界面D"

8) Fetch work items using saved 查询 id

Explicit:

node scripts/workitems.js 查询-id --project "Project Name" --id "查询_图形界面D"

With defaults from .env:

node scripts/workitems.js 查询-id

9) 列出 work items closed in the last 7 days

Using the default project from .env:

node scripts/workitems.js closed-last-week

With an explicit project:

node scripts/workitems.js closed-last-week --project "Project Name"

10) 导出 报告 data as JSON

Default saved-查询 导出 using .env defaults:

node scripts/导出-报告.js

Explicit saved-查询 导出:

node scripts/导出-报告.js 查询-id \ --project "Project Name" \ --id "查询_图形界面D" \ --格式化 json \ --out 查询-data.json

Explicit sprint summary 导出:

node scripts/导出-报告.js sprint-summary \ --project "Project Name" \ --team "Team Name" \ --格式化 json \ --out sprint-summary.json

11) Build Excel workbook from 导出ed JSON python3 scripts/build_excel_报告.py \ --输入 输出/查询-data.json \ --输出 输出/查询-报告.xlsx

Ask Claw机器人 in plAIn English

These 请求s should map to the 技能 without manual script execution:

show my Azure DevOps projects how many teams do we have? 列出 all team members in team can you 列出 the sprints? 生成 the Azure DevOps 报告 re生成 the excel 列出 all work items closed in last week summarize closed items from last week show current 进度 of sprint 07 which team member has most open items? References

Read these only if needed:

references/field-m应用ing.md for normalized field choices references/报告-types.md for 报告 pre设置s and 图表 ideas references/API-notes.md for 端点 notes and PAT scope 图形界面dance