Hi Rohan, While I can't answer your question specifically regarding documentation on the DB structure, I thought you might like to know that there should be a powertool called TFSServerManager coming along soon that will help gather some great data as well. Brian Harry has been using this tool to provide the TFS Dogfooding stats to give you an idea of what to expect. Check out his blog post at http://blogs.msdn.com/bharry/archive/2007/01/22/tfsservermanager-powertool.aspx Hopefully now that Orcas Beta 1 has shipped, Brian will be able to finish off his little project :) Cheers Anthony Borton Microsoft MVP - Team System AB Training Pty Ltd | Mobile: (61) 408 302 173 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> | Blog: www.myvstsblog.com <http://www.myvstsblog.com/>
________________________________ From: [EMAIL PROTECTED] on behalf of Pynor, Rohan [Audatex UK] Sent: Thu 26/04/2007 9:44 PM To: [EMAIL PROTECTED] Subject: [OzTFS] Extracting Statistics from TFS Hi all, Just wondering if anyone has any experience of (or knows of any resources around) describing the structure of the underlying databases in TFS - especially around the work items? I am trying to run daily / weekly queries to extract data to provide statistics to management, Thanks, Rohan Pynor Software Architect DDI: +44 (0)118 923 5660 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Audatex (UK) Ltd The Forum Station Road Theale Reading Berkshire RG7 4RA Tel: +44 (0)118 932 3535 Mobile: +44 (0)7793554950 www.audatex.co.uk <http://www.audatex.co.uk/> <https://me-au.server-secure.com/Exchange/mb90545a/Drafts/RE:%20%5BOzTFS%5D%20Extracting%20Statistics%20from%20TFS.EML/1_multipart/image002.jpg> Global knowledge. Local focus. This e-mail, any associated files and the information contained in them are confidential and is intended for the addressee(s) only. If you have received this message in error please notify the originator and delete the email immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. E-mails to and from the company are monitored for operational reasons and in accordance with lawful business practices. Any opinions expressed are those of the individual and do not necessarily represent the views of the company. The company does not conclude contracts by email and all negotiations are subject to contract. We make every effort to maintain our network free from computer viruses but accept no responsibility for any viruses which might be transferred by this e-mail. OzTFS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net OzTFS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net
<<winmail.dat>>
