We have been asked if you can capture the Date of the Baseline (this is the date that you set the baseline).
The baseline save date is only available from the ProjectServer Draft and Published database, NOT from the Reporting database. Thanks to Thomas Hausla for providing the following script to see the ‘Save Date’.
Run this against the Draft or Published database to get the date for the creation and last modification of each baseline:
select distinct p.PROJ_NAME, b.TB_BASE_NUM, b.MOD_DATE, b.CREATED_DATE
from MSP_PROJECTS p
inner join MSP_TASK_BASELINES b
on p.PROJ_UID = b.PROJ_UID
order by PROJ_NAME, TB_BASE_NUM
PPM Works is a full service Microsoft Project and Portfolio Management consultancy, focused on Microsoft Project Server and Microsoft SharePoint platforms. We believe in partnering with our clients to exceed expectations and build long lasting rewarding partnerships. We are continuously building a knowledge base of multiple tips, tricks and solutions to make your use of Microsoft Project Pro as quick and easy as possible. Contact us for more information.
Stay updated with the latest of Project Online/Server 2013 with us: Subscribe. Check our future events!
Subscribe to our webcast email list for updates on our upcoming webinars!
Visit our FAQ Page for access to our tool box.