Forum Discussion

Brass Contributor

Apr 14, 2024

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 baseli...

Paul_Mather

MVP

Apr 15, 2024

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-S

Brass Contributor

Apr 15, 2024

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?

Paul_Mather
MVP
Apr 15, 2024
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
- Ana-S
  Brass Contributor
  Apr 15, 2024
  Oh I see. Wish they published that information so we could pick that information on our SSRS. Even if it stored in published or draft schema, it would be easy to pick without putting workaround.
  Thank you Paul.