none
QUERY SQL - Change history between baselines in Project Server 2010 RRS feed

  • Question

  • Hello Guys

    It is possible to identify in a SQL query which changes were made between different baselines?

    Can provide a code example or on the subject. 

    Thank you.


    Obrigado por contactar o fórum Microsoft Technet!

    Friday, September 26, 2014 5:42 PM

Answers

  • Hi,

    The MSP_EPMTask and MSP_EPMTaskBaseline table columns in the reporting schema can be used to compare current project schedule against different baselines (use baseline number to filter the required baseline). In the same way different baselines can be compared, however, the comparison will make sense at project level as different projects may use different baseline sets (0,1,2,...,10) unless you have an organization level baselining methodology/process (e.g. use baseline 0 in January, 1 February etc.) 

    Also, the date when a particular baseline was saved can be found in the published database/schema

    Hope this helps

    Paul

    Sunday, September 28, 2014 4:42 PM

All replies

  • Hi,

    The MSP_EPMTask and MSP_EPMTaskBaseline table columns in the reporting schema can be used to compare current project schedule against different baselines (use baseline number to filter the required baseline). In the same way different baselines can be compared, however, the comparison will make sense at project level as different projects may use different baseline sets (0,1,2,...,10) unless you have an organization level baselining methodology/process (e.g. use baseline 0 in January, 1 February etc.) 

    Also, the date when a particular baseline was saved can be found in the published database/schema

    Hope this helps

    Paul

    Sunday, September 28, 2014 4:42 PM
  • Hello Paul.

    Thank you.


    Obrigado por contactar o fórum Microsoft Technet!

    Thursday, October 9, 2014 12:51 PM