I want to find a method to query our TFS Server 2013 for test cases that have been switched from "Not Automated" or "Planned" to "Automated" within a given time period. I know I can create a query in Visual Studio that would pull all automated cases, and can add "Changed Date" > @today - 30 as a clause, but the methods that some of the manual QA testers user to update and change test cases end up pulling in a lot more than just the recently automated. Is there a way to create a sub query on the History field or query the cube directly for this information?

Here's what I have so far:

A screen shot of my automation query

  • So far, it looks like the only way to do this is to create a report using the TFS data warehouse. It doesn't look like the Visual Studio IDE provides a method to do this.
    – Ryan Cox
    Jul 18, 2014 at 18:34

1 Answer 1


TFS now has a REST API that you can engage with.

There are some sample queries that you can perhaps find out the information you want here.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.