Microsoft Test Manager–Test Attachment Cleaner tool

One of my favourite Test Manager feature is the data and diagnostics that collects information during my test runs to pass on in any bugs I log or get attached to my test run. The action recording proves the test case steps were followed, they allow me to fast forward the test next time I run the test or iterations. It has eliminated the bug state “Cannot Reproduce” The time all this data collected saves me in dealing with just bugs is unlimited. Developers love it too, they can diagnose bugs in no time.

I wonder if this helps in reducing the affect of the bug fix breaking other code. Now that would be interesting to investigate. Next project I’ll have to investigate all Test Impact and track how many were due to code changes involved in a bug fix.

Now I am in year five of using Test Manager and Visual Studio data diagnostics and my test runs and bugs are adding up in quantity therefore my database is getting full of all these test attachments. Do I really need to store the test attachments from a project that is done and 9 months old. Maybe not. What can I do?

The Test Attachment Cleaner a command line power tool that accepts parameters to remove test attachments form the database. Here are some examples:

  • Identify list of attachments taking up database space of more than 1 GB per attachment
  • View/Delete IntelliTrace log files over a size of 500 MB
  • View/Delete all Video log files with Test run creation date older than specific date with no active bugs
  • View/Delete all TRX & COV log files for test runs that happened between 30 and 90 days in age & do not perform the Linked Bugs lookup query
  • View/Delete all custom/user attachments over size of 5 MB with no active or resolved bugs on test runs between 2 dates

Find out more and download Test Attachment Cleaner

If you need to keep the test attachment data it can be stored remotely which is setup in the Test Plan properties, test settings.


Test Manager, The Story of a

I am a member of the The Software Testing Club which is a global and professional community of software testers. The community shares information through online question and answer sessions and access to test related bloggers, updates on testing events worldwide, The Testing Planet online articles, and much more. If you  are not a member I highly suggest you join. Follow the link above.

A member of the club, Rob Lambert wrote a story “The Story of a Test Manager” that I spent an hour while drinking my morning coffee reading. The story is fictional however, I bet you can relate to the main points through your own experiences as a software tester. As I read the story I wanted to tell the characters about TFS2010 but then I want to tell everyone even my hair dresser. My dogs love hearing the words TFS they think it’s a cookie!  Microsoft TFS nerd and proud of it.

Thanks to Rob Lambert for a great story.