
Metrics without visibility are just noise. These are the kinds of Jira queries I use to keep an ART honest โ paired with how AI turns raw results into the story leaders actually need. (JQL examples; adapt field names to your instance. A few cross-team queries assume standard link types or Jira Align.)
status = Blocked AND updated <= -5d ORDER BY updated ASCFlagged is not EMPTY AND resolution = Unresolvedissue in linkedIssues("PROJ-123", "is blocked by")Ask AI in plain English โ โshow every blocker older than a week across Teams AโCโ โ and it writes the JQL for you. Then paste the export back and ask it to group by owning team and name the dependency causing the most downstream blockage. In seconds you get the story that PI Planning usually needs a room and a wall of sticky notes to uncover.
sprint in openSprints() AND status not in (Done, Closed)status = "In Progress" AND updated <= -3d ORDER BY updated ASCstatus changed to Done during (-14d, now())JQL pulls the items, but it can't compute cycle time or spot a trend on its own. Feed the results to AI (or a Copilot-connected dashboard) and ask it to calculate average cycle time, flag WIP above the limit, and name the two stories most likely to carry over. That turns a flat list into a forecast โ the shift that took teams from 70% to 92% predictability.
sprint in openSprints() AND type = Story AND "Story Points" is EMPTYsprint in openSprints() AND created >= -5dPoint AI at the sprint's planned-vs-current scope and it drafts your Say/Do narrative: what was committed, what changed mid-sprint, and the trade-off conversation that should have happened. That's the exact insight that turns a missed sprint into a productive leadership discussion.
priority in (Highest, High) AND resolution = Unresolved AND updated <= -7dstatus = "In Progress" AND assignee is EMPTYtype = Bug AND resolution = Unresolved AND created <= -14d ORDER BY priority DESCAsk AI to triage the list into a Green / Yellow / Red view with a one-line โwhyโ and a suggested mitigation for each item. That's your health report โ pre-drafted, defensible, and ready before the leadership sync instead of scrambled the night before.
project in (TEAMA, TEAMB, TEAMC) AND status = Blockedtype = Feature AND "Program Increment" = "PI-2026.3" AND resolution = UnresolvedAcross a 15โ17 person train, AI turns these cross-project queries into a single PI health summary โ features at risk, the dependency web, and the one or two threads that could derail the increment โ refreshed continuously instead of hand-assembled every Friday.
In regulated environments, sensitive or client data never goes into public AI tools. I use enterprise Copilot with proper data governance and access controls โ responsible AI is part of the delivery, not an afterthought. That's how you get the speed of AI without the audit risk.