Baseline Last Save

[Cesar Vilela]

In project professional when saved the Baseline for the second time, it
appears the date of it finishes time that was saved baseline. Example
“Baseline (last saved on Tue 15/8/06). Where that she is stored this date? If
it will be in the Bank in which table?

Cesar Vilela

 

[Kevin W Flanagan]

Cesar-

I hope I understand what you are looking for. The following SQl code will
get the current baseline start and finish dates for the project from the
database.

select TASK_BASE_START, TASK_BASE_FINISH from MSP_TASKS
where PROJ_ID = ### and TASK_UID = 0 (
(Project ID showing in Manage Windows Sharepoint Services SItes in PWA)
(Task uid zero is the data for the overall project)


Hope this helps.

Kevin

 

[Cabral]

Hi Kevin and Cesar.
I think I´m looking for the same information: the date and time the
baseline was saved.
I´ve created a project, inserted the tasks, saved and published it.
Then I saved a baseline. Now it shows "Baseline (last saved on Wed
16/08/06 18:19)".
Where can I find this info (date/time)?

Kevin´s SQL code returned the following for me:

TASK_BASE_START TASK_BASE_FINISH
16/08/2006 08:00:00 16/08/2006 08:00:00

Regards,

Cabral

Kevin W Flanagan escreveu:

 

[Kevin W Flanagan]

I have dome some further research and found that this piece of information is
not stored in the dtabase but is captured within the program and cannot be
obtained outside of being displayed inside of MS Project.

 

[Cabral]

Well, at least we can get the date
My idea is to have a place listing all project´s baselines made by the
project managers at the beginning of their projects. From time to time
I would like to consult the Project Server database if there is any new
baseline created, which is wrong, and then ask the PM why or inform the
high-level management.

Regards,

Cabral

Kevin W Flanagan escreveu: