{"id":4593,"date":"2012-08-14T10:09:08","date_gmt":"2012-08-14T10:09:08","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2012\/08\/14\/test-attachment-version-control-and-database-sizes-in-team-foundation-server\/"},"modified":"2019-02-14T17:59:06","modified_gmt":"2019-02-15T01:59:06","slug":"test-attachment-version-control-and-database-sizes-in-team-foundation-server","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/test-attachment-version-control-and-database-sizes-in-team-foundation-server\/","title":{"rendered":"Test Attachment, Version Control and Database sizes in Team Foundation server"},"content":{"rendered":"<p><font size=\"3\">One of our ALM Rangers, <a href=\"http:\/\/mskold.blogspot.com\">Mattias Sk\u00f6ld<\/a>, was finding that he was recreating the same SQL queries to determine the size of his Test attachments, Version control etc.&#160; With this in mind he has now extended his <\/font><\/p>\n<h3><font size=\"3\"><a href=\"http:\/\/visualstudiogallery.msdn.microsoft.com\/11f5e313-ced1-4713-9794-d7300c7d12e0\">TFS Administrators Toolkit<\/a> to include this functionality. <\/font><\/h3>\n<pre><code>&lt;p&gt;&lt;font size=\"3\"&gt;&lt;\/font&gt;&lt;\/p&gt;    &lt;p&gt;&lt;a href=\"http:\/\/visualstudiogallery.msdn.microsoft.com\/11f5e313-ced1-4713-9794-d7300c7d12e0\"&gt;&lt;img title=\"clip_image002\" style=\"border-left-width: 0px;border-right-width: 0px;border-bottom-width: 0px;padding-top: 0px;padding-left: 0px;padding-right: 0px;border-top-width: 0px\" border=\"0\" alt=\"clip_image002\" src=\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2012\/08\/1351.clip_image002_6FBD30BD.gif\" width=\"422\" height=\"352\" \/&gt;&lt;\/a&gt;&lt;\/p&gt;  &lt;p&gt;If you haven\u2019t used the TFS Administrators Toolkit it also offers: &lt;\/p&gt;  &lt;p&gt;&lt;strong&gt;&lt;strong&gt;Test Attachment Sizes        &lt;br \/&gt;&lt;\/strong&gt;&lt;\/strong&gt;List test attatchment size per teamproject, what kind and extensions, Clean projects directly from the UI by calling Test Attachment Cleaner &lt;\/p&gt;  &lt;ul&gt;   &lt;li&gt;&lt;strong&gt;Update reports &lt;\/strong&gt;      &lt;br \/&gt;Push new reports from a template to selected team project.&amp;#160; &lt;\/li&gt;    &lt;li&gt;&lt;strong&gt;Update Work Item Types &lt;\/strong&gt;      &lt;br \/&gt;Push work item type definitions to multiple team projects &lt;\/li&gt;    &lt;li&gt;&lt;strong&gt;Source control folder size        &lt;br \/&gt;&lt;\/strong&gt;Get a feeling for team projects size in source control &lt;\/li&gt;    &lt;li&gt;&lt;strong&gt;Search for large files in source control        &lt;br \/&gt;&lt;\/strong&gt;Search on size for Source control items &lt;\/li&gt; &lt;\/ul&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>One of our ALM Rangers, Mattias Sk\u00f6ld, was finding that he was recreating the same SQL queries to determine the size of his Test attachments, Version control etc.&#160; With this in mind he has now extended his TFS Administrators Toolkit to include this functionality. &lt;p&gt;&lt;font size=&#8221;3&#8243;&gt;&lt;\/font&gt;&lt;\/p&gt; &lt;p&gt;&lt;a href=&#8221;http:\/\/visualstudiogallery.msdn.microsoft.com\/11f5e313-ced1-4713-9794-d7300c7d12e0&#8243;&gt;&lt;img title=&#8221;clip_image002&#8243; style=&#8221;border-left-width: 0px;border-right-width: 0px;border-bottom-width: 0px;padding-top: 0px;padding-left: 0px;padding-right: [&hellip;]<\/p>\n","protected":false},"author":81,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[228,253,1],"tags":[],"class_list":["post-4593","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-admin-licensing","category-azure-devops-server","category-devops"],"acf":[],"blog_post_summary":"<p>One of our ALM Rangers, Mattias Sk\u00f6ld, was finding that he was recreating the same SQL queries to determine the size of his Test attachments, Version control etc.&#160; With this in mind he has now extended his TFS Administrators Toolkit to include this functionality. &lt;p&gt;&lt;font size=&#8221;3&#8243;&gt;&lt;\/font&gt;&lt;\/p&gt; &lt;p&gt;&lt;a href=&#8221;http:\/\/visualstudiogallery.msdn.microsoft.com\/11f5e313-ced1-4713-9794-d7300c7d12e0&#8243;&gt;&lt;img title=&#8221;clip_image002&#8243; style=&#8221;border-left-width: 0px;border-right-width: 0px;border-bottom-width: 0px;padding-top: 0px;padding-left: 0px;padding-right: [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/4593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=4593"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/4593\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=4593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=4593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=4593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}