Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Where in the published database are the baseline 'saved-on' dates

Răspuns Where in the published database are the baseline 'saved-on' dates

  • Tuesday, 29 May 2012 6:14 PM
     
     
    Sign In to Vote
    0

    I'm using Project Server 2007.  I want to query the published database for the dates baseline 1, 2, and 3 were set via Project Professional.  I know I can get this data if I open the plan, go to Tools --> Tracking --> Set baseline (in the drop-down I can see the date the baseline was saved).  But where in the published database is this date stored? 

    Dave Shultz, PMP

     

All Replies

  • Tuesday, 29 May 2012 8:38 PM
    Moderator
     
     
    Sign In to Vote
    0
    Unfortunately not all data is copied to the reporting db.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

     
  • Wednesday, 30 May 2012 5:08 AM
     
     
    Sign In to Vote
    0

    See if this helps you in getting what you are looking for:

    Database reference - ProjectServer_Reporting  

    dbo.MSP_EpmTaskBaseline


    Abhijeet M. Mohite ------------------------------------------------------------------------------------------------------------------------------------------If you found this post helpful, please "Vote as Helpful";. If it answered your question, Plase "Mark as Answer"

     
  • Wednesday, 30 May 2012 11:48 AM
    Moderator
     
     
    Sign In to Vote
    0

    Just to point out if it helps....best practice is to always keep the latest baseline stored in Baseline0, then copy it with each change to Baseline1, 2, 3, etc.  That way, all reports are always based off of Baseline0.

    Not sure why you're looking to get the baseline save date - but if it's simply to identify the most recent baseline, then the above practice would also resolve the issue without the need for querying the Published database.

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

     
  • Friday, 1 June 2012 3:05 PM
     
     Answered
    Sign In to Vote
    0

    Hi, 

    This query display Project Name, Duration, task baseline start date, task baseline finish date and task  baseline created date

    SELECT     MSP_PROJECTS.PROJ_NAME, MSP_TASK_BASELINES.TB_BASE_NUM, MSP_TASK_BASELINES.TB_BASE_DUR, 
                          MSP_TASK_BASELINES.TB_BASE_START, MSP_TASK_BASELINES.TB_BASE_FINISH, MSP_TASK_BASELINES.CREATED_DATE
    FROM         MSP_TASK_BASELINES INNER JOIN
                          MSP_PROJECTS ON MSP_TASK_BASELINES.PROJ_UID = MSP_PROJECTS.PROJ_UID

    Regards.

    MCTS, MCITP