Files
Stefan Broenner 36845831ec Publish privacy-safe usage analytics (#816)
* Add privacy-safe usage analytics reporting

Co-authored-by: Copilot App <223556219+Copilot@users.noreply.github.com>

Copilot-Session: 915c2266-658e-45b7-ae7d-c9213c810f01

* Fix analytics changeset package

Co-authored-by: Copilot App <223556219+Copilot@users.noreply.github.com>

Copilot-Session: 915c2266-658e-45b7-ae7d-c9213c810f01

* Make analytics report public-friendly

Co-authored-by: Copilot App <223556219+Copilot@users.noreply.github.com>

Copilot-Session: 915c2266-658e-45b7-ae7d-c9213c810f01

* Finalize public usage analytics

Co-authored-by: Copilot App <223556219+Copilot@users.noreply.github.com>

Copilot-Session: 915c2266-658e-45b7-ae7d-c9213c810f01

* Harden analytics validation

Co-authored-by: Copilot App <223556219+Copilot@users.noreply.github.com>

Copilot-Session: 915c2266-658e-45b7-ae7d-c9213c810f01

---------

Copilot-Session: 915c2266-658e-45b7-ae7d-c9213c810f01
2026-08-28 09:45:09 +02:00
..

Azure Infrastructure

This directory contains the Azure Application Insights infrastructure used for telemetry development and validation.

Files

File Purpose
appinsights.bicep Application Insights deployment entry point
appinsights.parameters.json Production telemetry deployment defaults
appinsights-test.bicep Test telemetry deployment entry point
appinsights-test.parameters.json Test telemetry deployment defaults
appinsights-resources.bicep Shared Application Insights resources and ingestion-time privacy transforms
deploy-appinsights.ps1 Application Insights deployment helper
configure-analytics-oidc.ps1 Read-only GitHub Actions workload identity setup

The workspace transform drops noisy runtime metrics and rejects every AppExceptions row that was not explicitly sanitized by ExcelMcp. Exception messages and stack traces are never retained; only approved type, source, and project-owned failure-site classifications are ingested.

Public usage analytics

The weekly analytics workflow uses Azure workload identity federation rather than a client secret. A maintainer with permission to create Entra applications and role assignments runs:

.\infrastructure\azure\configure-analytics-oidc.ps1

The script grants the workflow only Log Analytics Reader on excelmcp-logs and configures the repository's non-secret Azure identifiers. It cannot write telemetry or change Azure resources after setup.