Share via

Determining Process Template of an existing Team Project in TFS 2012

  • 09/27/2013

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. :-)

Comments

  • Anonymous
    October 16, 2013
    I Tried it with below query- it was executed successfully, but Zero row was affected...did not get any information. 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 '%TestProject%')

  • Anonymous
    October 17, 2013
    The comment has been removed

  • Anonymous
    October 26, 2013
    Hey Trevor This does not seem to work on TFS 2013. We only have these names in the tbl_prject_properties table: Microsoft.TeamFoundation.Team.Default MSPROJ No "Process Template" unfortunately :(

  • Anonymous
    October 27, 2013
    I'll look into this tomorrow during office hours and loop back.

  • Anonymous
    February 09, 2014
    I tried in TFS 2013 and the following query does work: Select tbl_projects.project_name as "Team Project", tbl_project_properties.value as "Process Template" from tbl_projects inner join tbl_project_properties on tbl_projects.project_id = tbl_project_properties.project_id where tbl_project_properties.name like '%Process Template%'

  • Anonymous
    October 08, 2014
    Trevor any update here for 2013 specifically 2013.3

  • Anonymous
    February 18, 2015
    Hi! I have tried the query too and the result ist just a subset of all templates which were uploaded to TFS 2013. <select * from tbl_ProcessTemplateDescriptor> get 'all' (I think so) templates, but how is the relation to the project(s)?

  • Anonymous
    February 20, 2015
    in TFS 2013, We can check process template used to create the Team Project as below: Go to Team Explorer -> Documents -> Process Guidance , then open ProcessGuidance.html. it will tell us which template used to create that team project.

  • Anonymous
    March 19, 2015
    I also couldn't see any results from the above queries

  • Anonymous
    March 19, 2015
    (This comment has been deleted per user request)

  • Anonymous
    April 21, 2015
    Additional answers available from StackOverflow: stackoverflow.com/.../check-current-process-template-in-tfs stackoverflow.com/.../how-can-i-find-the-process-template-of-my-tfs-project

  • Anonymous
    May 03, 2015
    You can try something in TFS 2013 using the XML data field like: SELECT (SELECT project_name FROM [Tfs_DefaultCollection].[dbo].[tbl_projects] where  [project_id]=[Tfs_DefaultCollection].[dbo].[tbl_project_properties].project_id) as pname, IIF(CHARINDEX('CMMI', [value], 1)>0, 'CMMI', IIF(CHARINDEX('.SCRUM', [value], 1)>0, 'SCRUM', IIF(CHARINDEX('.ESCRUM', [value], 1)>0, 'ESCRUM', 'AGILE'))) AS ProcessType      FROM [Tfs_DefaultCollection].[dbo].[tbl_project_properties]   where [name] like '%MSPROJ%'    order by 1

  • Anonymous
    May 26, 2015
    If you are using TFS 2013 then query needs to be modified as database name for TFS DB and table names are changed little bit in TFS 2013. Below query works perfectly fine for me in TFS 2013 server. In below query Tfs_Projects is my collection name so TFS database got created by name Tfs_Projects. If your project collection name is DefaultCollection then it would be Tfs_DefaultCollection. If your collection name is ABCXYZ then TFS database would be Tfs_ABCXYZ. So you have to make small change in below query as per your TFS collection name. SELECT [name], [value]      FROM [Tfs_Projects].[dbo].[tbl_project_properties]   where [name] like '%Process%' and [project_id]=(SELECT [project_id] FROM [Tfs_Projects].[dbo].[tbl_Project] where ProjectName like '%<your TFS project name>%')

  • Anonymous
    May 26, 2015
    The comment has been removed

  • Anonymous
    March 02, 2017
    It works with TFS 2015. You've got to escape underscores in your project name. That's what we did wrong first.