What this app does
Pulls two Azure DevOps query results — active work items and recently changed work items — and visualises them by person or project. You can also upload CSV exports instead of connecting live.
The three tabs
ACTIVE ITEMS
Work currently assigned and in flight. Each item shows its state and how long ago it was last touched.
RECENT CHANGES
Items that have been modified recently. Shows what state they moved to and who changed them. Includes the Status Grid view.
TEAM VIEW
One card per person (or project). Merges active and recent items into a single list sorted by most recently touched — so you see what each person is actually working on right now.
Age pills (Active Items)
4h ago
Changed within the last 4 hours — fresh.
12h ago
Changed within the last day — healthy.
2d ago
Not touched in 1–3 days — may need attention.
5d ago
Not touched in 3+ days — stale, worth a check-in.
Status colours (Recent Changes)
New
Just created or proposed — not yet started.
In Progress
Actively being worked on.
Active
Picked up and in the board.
Resolved
Done and awaiting sign-off or verification.
Closed
Completed and filed away.
Status Grid (Recent Changes)
Groups each person into columns by status. Tap any item chip to see full details and open it in Azure DevOps. The count badges in each person header give you an instant at-a-glance summary without expanding.
⚠ Inactive toggle
Shows staff who have no active items or no recent changes within the threshold. The threshold is 1 day Tuesday–Friday, and 3 days on Monday to account for the weekend. Requires staff names to be configured.
The staff list also acts as a filter — if names are saved, only those people appear in all views.
Commits in Team View
When connected via API, the last 7 days of commits are fetched across all repositories and matched to team members by author name and email. Commits are shown beneath the work item they are linked to. Commits with no work item link appear in a separate section at the bottom of each person card.
Commit matching requires a PAT with Code (Read) scope. Author name matching is best-effort — if commits are not appearing, check that the commit author name matches the person's display name in ADO. Commits are not shown in the By Project view.
API / Live: Connect directly using your Azure DevOps org URL, a Personal Access Token, and two saved query IDs. Hit Refresh to pull fresh data at any time.
Upload CSV: Export queries from Azure DevOps as CSV and upload them here for offline use or testing.
Share Settings: Exports your org URL, PAT, query IDs and staff list as an AES-256 encrypted string. Share the string with a colleague and give them the passphrase separately — they paste it into Import to get set up instantly.
All dates in the data are treated as UTC and displayed in your local timezone.