Way to find Unresolved work items owned by archived users

We have a set of work items that we've run across where the work item is Unresolved by the "owned by" person is no longer with the team or with the company, and they show up as "archived user". However, i can't find a way to actually build a query to hunt for these so that I can go find a new owner for them.

I don't know of a way to write a work item query that will select only archived users, so I don't think you can do exactly what you want. But I have another idea that might work...

Create a query that finds all open work items assigned to your team, sorted by owner. When you run the query, the work items assigned to the wrong people should be easy enough to find. (Though it might be a little tedious to page through the results if you have lots and lots of work items assigned to the correct people.)

--
David Olsen, IBM Rational, Jazz Process Team

We have a set of work items that we've run across where the work item is Unresolved by the "owned by" person is no longer with the team or with the company, and they show up as "archived user". However, i can't find a way to actually build a query to hunt for these so that I can go find a new owner for them.

I don't know of a way to write a work item query that will select only archived users, so I don't think you can do exactly what you want. But I have another idea that might work...

Create a query that finds all open work items assigned to your team, sorted by owner. When you run the query, the work items assigned to the wrong people should be easy enough to find. (Though it might be a little tedious to page through the results if you have lots and lots of work items assigned to the correct people.)

--
David Olsen, IBM Rational, Jazz Process Team

Unfortunately, it is a bit bigger than just a team ... I am an RTC Administrator trying to "clean up" prior to migrating work to a different project area. And my "team" basically has about 600 people in it :-)

Susan