TFS 2010 - Calculating Various Version Control Metrics
-
2012年4月16日 下午 12:23
I want to get at the following information (and I guess it has to be via the databases directly, that's why I posted to the Administration forum):
#1 I have a project in a collection (contains multiple projects). How do I calculate the total size of sources?
#2 Someone has checked in say ClosedXML.dll. They updated it x times. How do I calculate the total size for all deltas? (including branches it was branched to)
#3 "Checked in bytes / day". Again, on the database level with all deltas.
Can anyone point me to SQL statement / ... that can do this sort of analysis?
Chris
Christoph Wille - Glengamoi Alumni - Realnamen sind ein Gebot der Höflichkeit in der Community
- 已移動 Trevor HancockMicrosoft Employee, Moderator 2012年4月18日 下午 05:15 At its core this is a VC question. (From:Team Foundation Server - Administration)
所有回覆
-
2012年4月18日 上午 01:45版主
Hi Chris,
Thanks for your post.
I’m currently looking into this issue and will give you an update as soon as possible.
John Qiao [MSFT]
MSDN Community Support | Feedback to us
-
2012年4月23日 下午 01:52擁有者
Hi Christoph,
We do not have any readymade queries for the information you request. However, I am going to continue looking to see if I can find anything. I plan on updating you again tomorrow.
Thanks and have a great day.
Trevor Hancock (Microsoft)
Please remember to "Mark As Answer" the replies that help. -
2012年4月23日 下午 05:42
A SQL query for SSMS is perfectly fine (I knew there aren't any precanned reports, that's why I asked for guidance. Trying to reverse-engineer the collection database model myself wasn't high on my list...).
Chris
Christoph Wille - Glengamoi Alumni - Realnamen sind ein Gebot der Höflichkeit in der Community
-
2012年4月24日 下午 09:01擁有者
Chris,
Research continues on this. We will do our best to update you tomorrow morning. Sorry for the delay.
Trevor Hancock (Microsoft)
Please remember to "Mark As Answer" the replies that help. -
2012年4月25日 下午 07:22擁有者
Chris,
Sorry for the delay. We've not been able to determine a way to do all this and I'm afraid we're at a point where we can't continue to research this based on a forum thread. We may be able to help further, but it will require a support case from here. If you cannot determine your answer here or on your own, consider opening a support case with us. Visit this link to see the various support options that are available to better meet your needs: http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone.
Trevor Hancock (Microsoft)
Please remember to "Mark As Answer" the replies that help.
