locked
How to determine what Process template an existing TFS 2012 project is configured with? RRS feed

  • Question

  • Recently I re-placed a TFS administrator and was asked to customize some project work items(WI). Before I customized the WI, I needed to know what current existing projects were using the process template I was customizing.  Hence how can I determine what each template each & every project is using?

    I first went to the Process Template Manager under downloaded all the templates that were previously uploaded into the project server.  I then went to each & every project and exported all the templates and then tried comparing each xml file to see what files matched.  This method is not consistent because two process template XML's can have the same functionality and still not compare equally.  Also remember that a lot of the projects are not integrated with sharepoint and thus have no documentation until the Docs folder when the project was created.

    Is there an easy way to determine this from the TFS client or web client?  If not, is there a command line I can execute or a configuration file to access to figure this out?  Of course I am not even bringing customization into the picture to muddy up the waters.

    Thanks for any help in advance.


    Thursday, February 23, 2017 4:44 PM

Answers

  • TFS Team Project Manager allows you to compare work items against an original template, among other things. You can find it here:

    https://teamprojectmanager.codeplex.com/documentation#WorkItemConfigurationCompare



    If you have access to the TFS project collection database then the below SQL statement will get the process template for each team project in the project collection:

    select prj.project_name 'Team Project', prop.value 'Process Template' from [dbo].[tbl_projects] prj
    join [dbo].[tbl_project_properties] prop on prj.project_id = prop.project_id
    where prop.name = 'Process Template'

    Source: https://social.msdn.microsoft.com/Forums/vstudio/en-US/ee8475fa-6d3e-4969-acd9-7a1c603125d8/how-to-determine-process-template-for-existing-team-project-?forum=tfsworkitemtracking
    Thursday, February 23, 2017 4:50 PM
  • Hi Keith Langenberg,

    Thank you for posting here.

    There are several ways for you to determine the template based on the requirement category, API, query in database, third-party tool as the link provided by Niels. And I also suggest that you could try to use the following rest api:

    Get http://XXXX:8080/tfs/DefaultCollection2015U3/_apis/projects/AgileTest?includeCapabilities=true&api-version=1.0

    You could get the result about the template like the following:

    "capabilities": {
        "processTemplate": {
          "templateName": "Agile"
        },

    For more information about the rest api, you could refer to the following link:

    https://www.visualstudio.com/en-us/docs/integrate/api/tfs/projects#get-a-team-project

    Best Regards

    Limitxiao Gao


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, February 24, 2017 5:15 AM
    Moderator
  • Nels van 't Hof,

    Thanks for the info.  I took your SQL statement & sent it to our DBA's & they ran it on our TFS site collection and I got the list of process templates I was looking for.

    Friday, February 24, 2017 3:46 PM
  • Limitxiao Gao,

    Thanks for the API & info about 3rd party TeamProjectManager.  Until I get the curl command installed and the TeamProject Manager from hosted GitHub, I used the SQL command which gave me good results.  I will look in to the restAPI's along with writing some C# code.  Lots of info to get besides process templates. Again, thks.

    Friday, February 24, 2017 3:50 PM

All replies

  • TFS Team Project Manager allows you to compare work items against an original template, among other things. You can find it here:

    https://teamprojectmanager.codeplex.com/documentation#WorkItemConfigurationCompare



    If you have access to the TFS project collection database then the below SQL statement will get the process template for each team project in the project collection:

    select prj.project_name 'Team Project', prop.value 'Process Template' from [dbo].[tbl_projects] prj
    join [dbo].[tbl_project_properties] prop on prj.project_id = prop.project_id
    where prop.name = 'Process Template'

    Source: https://social.msdn.microsoft.com/Forums/vstudio/en-US/ee8475fa-6d3e-4969-acd9-7a1c603125d8/how-to-determine-process-template-for-existing-team-project-?forum=tfsworkitemtracking
    Thursday, February 23, 2017 4:50 PM
  • Hi Keith Langenberg,

    Thank you for posting here.

    There are several ways for you to determine the template based on the requirement category, API, query in database, third-party tool as the link provided by Niels. And I also suggest that you could try to use the following rest api:

    Get http://XXXX:8080/tfs/DefaultCollection2015U3/_apis/projects/AgileTest?includeCapabilities=true&api-version=1.0

    You could get the result about the template like the following:

    "capabilities": {
        "processTemplate": {
          "templateName": "Agile"
        },

    For more information about the rest api, you could refer to the following link:

    https://www.visualstudio.com/en-us/docs/integrate/api/tfs/projects#get-a-team-project

    Best Regards

    Limitxiao Gao


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, February 24, 2017 5:15 AM
    Moderator
  • Nels van 't Hof,

    Thanks for the info.  I took your SQL statement & sent it to our DBA's & they ran it on our TFS site collection and I got the list of process templates I was looking for.

    Friday, February 24, 2017 3:46 PM
  • Limitxiao Gao,

    Thanks for the API & info about 3rd party TeamProjectManager.  Until I get the curl command installed and the TeamProject Manager from hosted GitHub, I used the SQL command which gave me good results.  I will look in to the restAPI's along with writing some C# code.  Lots of info to get besides process templates. Again, thks.

    Friday, February 24, 2017 3:50 PM