Determining Process Template of an existing Team Project in TFS 2012

  • Article

Following comes to us from Premal Ghelashah:

 

I have always had difficulty in identifying the process template used to create a team project. One way is to go to Portal settings for the team project. There will be a process guidance document which will have information related to the process template used to create the Team Project, but that is only available when you've integrated with SharePoint on your TP... but what if you haven't?

Here's a way to find out using a simple SQL Select:

SELECT [name], [value]
      FROM [Tfs_DefaultCollection].[dbo].[tbl_project_properties]
   where [name] like '%Process%' and [project_id]=(SELECT [project_id]
 FROM [Tfs_DefaultCollection].[dbo].[tbl_projects]
 where project_name like '%<put project name here>%')

 

This implies you can access the TFS back-end SQL DB of course. If you can't, ask your admin for help. :-)