Reporting Changeset Details

I need to create a few reports containing the details of Changesets.

I want to report the same info that appears in the "Details for Changeser#<SetNumber> - SourceFiles What is the query to do that
What is the source for the stored procedure "prc_QueryChangeSet" - Can I safely use this stored procedure (i.e. without corrupting the data )
How can I get a list of all files in all unmerged changesets, grouped by changesets

Thanks in advance!

Doug Barker

www.cooltimbers.com

"Art for your soul."

Visual Studio Team System6

Hi Doug,

1) Could you clarify what information is "Details of Changeset # - Source files" Did you want to see what source files are in a particular changeset, or is there something more For this, you can get this information from the warehouse. You can do a join on the Changeset, Code Churn and File tables in TfsWarehouse.

2 & 3) I will contact someone on the Version Control team to take a look at these questions.

Thanks!

mauli

Hi, It looks like Richard answered your questions in this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=591475&SiteID=1

let me know if you need further assistance.

Mauli