title: Directly query TFS Warehouse using T-sql
body: <p>Hi I'm wondering if anybody has had any experience querying a Team Foundation Server store to retrieve current work item information. It is my understanding that the information I require is stored in the TFSWarehouse Database.</p>
  
  <p>I'm well aware that there are APIs that provide this functionality and I've used them myself. However these come with the requirement to install Team Explorer on any client PC that will reference the API.</p>
  
  <p>All I want is a list of Work Items with some selected fields such as Title, State and Created By.</p>
  
  <p>Has anybody attempted this themselves, and indeed does anybody know of any pitfalls with this approach?</p>
  
  <p>---------- EDIT 16/02</p>
  
  <p>Just to add after speaking with TreeUK. What would be great is if anybody perhaps has an example query, or maybe some explanation as to the table structure?</p>