Stack Overflow
Stack Overflow

Questions tagged [tfs-warehouse]

For questions regarding the Team Foundation data warehouse. When using this tag also include the more generic [tfs] tag where possible.

6 questions
1
vote
2 answers

Where is the story (product backlog item) description in TFS_Warehouse (TFS 2012)

I am trying to build an SQL query for stories stored in TFS_warehouse (TFS 2012). What I want is a simple list of stories including basic elements such as id's, titles and the description. I am however unable to locate the description in the…
styrmiro
  • 11
  • 2
0
votes
0 answers

Using Tfs_Warehouse.dbo.FactCurrentWorkItem, How do you get Request and project name from Query?

I am trying to get all current project names and request names from TFS that are not closed and have hotfix as '1'. This is the query I used Select Distinct wi.System_Title,TP.ProjectNodeName FROM Tfs_Warehouse.dbo.FactCurrentWorkItem FCWI INNER…
Glenville Pecor
  • 97
  • 10
0
votes
1 answer

TFS Warehouse field OriginalEstimate

One of our customer is using scrum based project and he is looking for the original estimate field in the warehouse table. As we know it's available for Agile based project but not for the scrum one's, is there any possible way to get the customized…
Rama
  • 89
  • 4
0
votes
1 answer

TFS 2010: Real time reporting

I would like to create a report that shows the iteration status in real time. I was able to create a query on the Tfs_Warehouse database (see below) however I found that this database is populated from the Tfs_Collection database on timely basis.…
duraid
  • 614
  • 7
  • 16
0
votes
1 answer

Where is the AD group name stored in TFS 2008?

The Team Foundation Server Administration Tool has a column called 'User' that contains the domain group that is being granted permissions to TFS. Searching through the TFSWarehouse table, I see the Person table, with the individual users, but can't…
user1202839
  • 365
  • 1
  • 5
  • 18
0
votes
1 answer

How Does TFS 2010 Build Logging send data to data warehouse

My questions is how TFS 2010 send its log to the TFS data warehouse? Does all the contents of the build.log are sent to TFS data warehouse? In what way, is it thru web service?
dba
  • 33
  • 4