A few days ago a co-worker sent out an e-mail asking if any of several team projects were still in use; if not, then they would be removed from Team Foundation Server.
Looking at the list it was easy enough to recognize a few active projects but others would take more investigation. After sending my feedback I thought a custom utility might be helpful in the future for the next round of potential deletion candidates. So, I decided to put the TFS Object Model (TFSOM) to use and created TFSunset (see screen shot below).
TFSunset uses the TFSOM to query the version control system and work item store for activity within a specified time range (e.g. the last 30 days). All team projects for a given team foundation server are searched. If no changesets have been created and no work items have been created/modified within the last 30 days (or whatever count you specify) then that team project will be listed.
Here is a screen shot showing the results of one search:
In the above example, the team project WalkingPage has not had any changeset or work item activity within the past two weeks.
Keep in mind that just because a team project is listed by this utility, that is no guarantee it has gone the way of OS/2 – you still need to perform your due diligence before deleting it from TFS. However, this utility should be able to help narrow down the list.
I am planning on posting the source code to the MSDN Code Gallery in the near future. For now, you can download the executable here.
Note: you will need to have Team Explorer 2008 installed prior to running this utility.