Report for tasks moved from one Sprint to another

Are you just moving the Task and leaving the parent work item in the original sprint?

If so, you could do a 'Work Items and Direct Links' query to return tasks where the parent has a different iteration path.

None that I know of.

I initially thought this would be easy. I.e. Query items with Iteration Path = currentIteration, and WAS EVER in previousIteration clause (or specify Iterations is necessary). Alas, the WAS EVER option doesn't seem to be available for the Iteration Path (Sprint) field 😞

There'd be a way using PowerBI consuming an Analytics view (with [include item History] option). But that's a disproportionate amount of effort (unless you're using it for other insights) 😞

I'd also be keen to know if anybody else finds an easy way.

Meantime, a couple of alternatives/crutches:
- We've added "Activation Date" field to Backlog Columns and Board Cards. It makes an Items age a bit more visible. That field gets auto-populated when Item moves from New to any In Progress state (if it's not standard, then we added a trigger or process-rule]. On the Board we color-code cards that have Activation Date > N days.
- I heard of some teams that add a "Carried Once", "Carried Twice" (and so on) Tag to Items as part of Sprint changeover. Thus giving visibility and options to Query/filter (... and more importantly, the option to do analysis and discussion about what might be going on with carried items).