index > Team Foundation Server - Reporting > Reporting Changeset Details

Reporting Changeset Details


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."

DougInGeorgia

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

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

Mauli Shah - MSFT
reply 3

You can use google to search for other answers

 

More Articles

Can't find links between Work item and test in the TfsWarehouse
Unplanned work report incorrect
Standard team project reports have empty parameter combos
Extra strain report (overeffor or sobreesfuerzo in spanish)
Source Control Reporting
Problem accessing TFSwarehouse using OLAP datasource in excel
Reports not accessible through project portal by remote user
SubReport ReportItems
Is there a way to select the executed test cases from the databas...
Possible Bug in Warehouseadapter
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

TFS Reporting does not work due to wareh…
SubReport ReportItems
How to Updating report from stored proce…
How to validate parameters in the rdl it…
Warehouse error question?
Render and Create PDF File directly from…
Quality Indicators Report
When trying to add a new VS2005 RDL file…
How the change in the data of Cube will …
Error 28806. Something is wrong with Re…
How to connect to Database?
Problem with DATE dimension of RTM Team …
Permissions Question with Reporting Site
How do I 'hide' a deleted item so it doe…
Another warehouse not updating :( - now …

Hot Articles

report designer don`t find all fields
TF53010 An unexpected exception occured …
Reporting on Plain Text Fields in Work I…
urgent: Connection Problems
Bug Rates Report - Getting very weird re…
Error Generating model for Olap Data Sou…
Only Team Sytem cube is visible
Unplanned work report incorrect
Problem with WI's and reportable="d…
How to create report on custom defined p…
Warehouse Troubleshooting Guide
Report not showing in Team Explorer
Where are the Models?
Error Executing reports
how to create entirely new report

Recommend Articles

What ?淒efault Value??is the correct one…
Render and Create PDF File directly from…
TFS reporting
After upgrading to latest VSTS reports a…
Reporting Services Error
Possible Bug in Warehouseadapter
Daily wise resource allocation in MS Pro…
Setting default parameter for project in…
AssignedTo names in reports
Restoring reports for a team project
Adding the Build_Type field to the TFS B…
Build metrics
Permissions Question with Reporting Site
Only one CUBE in Team Foundation Server
Quality Indicators Report