Reporting Changeset Details  
Author Message
DougInGeorgia





PostPosted: Team Foundation Server - Reporting & Warehouse, Reporting Changeset Details Top

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

  1. I want to report the same info that appears in the "Details for Changeser#<SetNumber> - SourceFiles What is the query to do that
  2. What is the source for the stored procedure "prc_QueryChangeSet" - Can I safely use this stored procedure (i.e. without corrupting the data )

  3. 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 System17  
 
 
Mauli Shah - MSFT





PostPosted: Team Foundation Server - Reporting & Warehouse, Reporting Changeset Details Top

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


 
 
Mauli Shah - MSFT





PostPosted: Team Foundation Server - Reporting & Warehouse, Reporting Changeset Details Top

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