none
project server 2010: obtaining the GUID of a project template RRS feed

  • Question

  • Hi,

    I have project templates and I need to get their GUIDs from pwa or project professional but I can not use the psi. Where can I find the GUIDs?

    Thanks,
    George 

    Monday, June 6, 2011 12:31 PM

Answers

  • They're stored in the Draft db.  Proj Type = 1 indicates a template.

    USE

    Project_Draft_DB_NAME

    SELECT

     

    PROJ_UID, PROJ_NAME, PROJ_TYPE FROM dbo.MSP_PROJECTS WHERE PROJ_TYPE =

    1


    Terrie T - MCTS - PMP - MBA****PMO & Project Server Admin
    Monday, June 6, 2011 1:15 PM
  • Hello George,

    I am afraid that its not easy to find the Guid of a template without using client object model or PSI.
    Any alternate process: Create project which no PM has the rights on those to edit . They can be published too , Use those project to create projects.
    As Terrie said about the DB query but It should be run in Draft database but as you know the direct Query of Draft, published database is not recommended and supported by MS.
    But in case you just need to get the data, here is the query which can ne run against Draft database:
    SELECT PROJ_UID, PROJ_NAME FROM MSP_PROJECTS
    WHERE PROJ_TYPE = 1
    --Proj_Type = 1 : Template
    Does that help?

    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    • Marked as answer by geo_d Tuesday, June 7, 2011 5:55 AM
    Monday, June 6, 2011 1:19 PM

All replies

  • Hi George,

    I had used in my previous assignment:

    In MS project object, 

    Project.GetServerProjectGuid method which returns the GUID for the enterprise project.

    http://msdn.microsoft.com/en-us/library/ff866819.aspx

    Does that help?


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, June 6, 2011 12:39 PM
  • Hi Amit,

    Thanks for the help but I don't want to use the PSI to get the GUID. I want to get the GUID directly by opening pwa web page or by using microsoft project client. Is there a way to do this?

    Thanks,
    George 

    Monday, June 6, 2011 12:43 PM
  • Hi George,

    The way I said earlier is the Project Object method which doesn't use PSI. 

    You can get the Project Guid :

    1. Access Project center in PWA

    2. Click on any project to view project level view

    3. Check the URL (http://Servername/pwa/Project%20Detail%20Pages/Schedule.aspx?ProjUid=4d849250-1aa5-471b-8f1a-dc8f64346932)

    Now you can see the ProjUid, easy way :)

    Does that help?


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    • Proposed as answer by Fix_105 Thursday, March 22, 2012 1:41 PM
    Monday, June 6, 2011 12:51 PM
  • When you're in the Project Details screen for a particular project, you'll see the GUID in the address bar (at least in 2007)

    Example:

    http://servername/PWA/ProjectDrillDown.aspx?_projectUID=(project_uid_string_here)

     


    Terrie T - MCTS - PMP - MBA****PMO & Project Server Admin
    Monday, June 6, 2011 12:52 PM
  • Hi Amit,

    Sorry I didn't explain well. I meant I don't want to use programming to obtain the GUID not just the PSI. As for the method you mentioned, I need to get the GUID of a template project not a regular project. The template projects do not appear in the project center and thus I can not click on them and check the URL. Any other methods?

    Thanks,
    George 

    Monday, June 6, 2011 12:54 PM
  • Whoops, sorry, I didn't read closely enough either.  I can't think of a way for a template - would using a SQL query be possible for you?
    Terrie T - MCTS - PMP - MBA****PMO & Project Server Admin
    Monday, June 6, 2011 1:04 PM
  • Hi Terrie,

    No, I am not able to query the database because it is on a different machine and I don't have access on it. But anyways if you have a query that gets the GUID please post it and I will try to get access to the database.

    Thanks,
    George 

    Monday, June 6, 2011 1:06 PM
  • They're stored in the Draft db.  Proj Type = 1 indicates a template.

    USE

    Project_Draft_DB_NAME

    SELECT

     

    PROJ_UID, PROJ_NAME, PROJ_TYPE FROM dbo.MSP_PROJECTS WHERE PROJ_TYPE =

    1


    Terrie T - MCTS - PMP - MBA****PMO & Project Server Admin
    Monday, June 6, 2011 1:15 PM
  • Hello George,

    I am afraid that its not easy to find the Guid of a template without using client object model or PSI.
    Any alternate process: Create project which no PM has the rights on those to edit . They can be published too , Use those project to create projects.
    As Terrie said about the DB query but It should be run in Draft database but as you know the direct Query of Draft, published database is not recommended and supported by MS.
    But in case you just need to get the data, here is the query which can ne run against Draft database:
    SELECT PROJ_UID, PROJ_NAME FROM MSP_PROJECTS
    WHERE PROJ_TYPE = 1
    --Proj_Type = 1 : Template
    Does that help?

    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    • Marked as answer by geo_d Tuesday, June 7, 2011 5:55 AM
    Monday, June 6, 2011 1:19 PM