Forum Discussion
Ana-S
Apr 14, 2024Brass Contributor
Last Saved Project Baseline date stored on SQL database
I am using Professional 2019 and on Prem Project server 2019. Project is baselined on Professional or in PWA (Project web app), through Set baseline option.
I am looking for the date that the baseline was created for the project, not the values that the baseline stores for tasks. Where is last saved baseline date stored on the database in order to extract that data for the SSRS report. Can anyone direct us to where that data is stored in SQL database?
4 Replies
Sort By
Hello Ana-S ,
An old blog post I wrote but this should help:
https://pwmather.wordpress.com/2011/08/20/report-on-project-server-baseline-save-dates-projectserver-ps2003-ps2007-ps2010-msproject-epm/Paul
- Ana-SBrass Contributor
Thank you so much Paul_Mather . Appreciate your response. I looked at the article and VB macro is used to store last saved baseline date in custom fields. That is a neat workaround.
Is there any way to know how it is showing the last saved date on PWA? It must store this data somewhere on the SQL database. Will the workaround work if the baseline is set through PWA?
Hello Ana-S ,
No it won't work for baselines created in the PWA UI. The out of the box date is not available to query in a supported way in the DB as it is not in the reporting schema.
Paul