K
Kevin
We are trying to find where is the baseline last saved date is stored
in Project Server 2003 in order to extract that data to a reporting
database.
We can find the both the PROJ_SAVED and the PROJ_PUB dates in SQL, but
no dates for when the baseline for a Project file was last saved (or
any of the baselines, for that matter).
The 'baseline last saved date' is clearly saved in the Project client
file, because you can view it in the Project client UI:
Tools>Tracking>Set Baseline>Baseline last saved (date)
Can anyone directed us to where that data is stored in Project Server?
Based on our research, we suspect the following:
1. The ‘baseline last saved date’ is not stored in the Project
Server SQL database as a discreet piece of data.
2. It is likely stored in a BLOB (binary file), and thus is not
available for extraction from the SQL database.
Thank you for you help.
-Kevin
in Project Server 2003 in order to extract that data to a reporting
database.
We can find the both the PROJ_SAVED and the PROJ_PUB dates in SQL, but
no dates for when the baseline for a Project file was last saved (or
any of the baselines, for that matter).
The 'baseline last saved date' is clearly saved in the Project client
file, because you can view it in the Project client UI:
Tools>Tracking>Set Baseline>Baseline last saved (date)
Can anyone directed us to where that data is stored in Project Server?
Based on our research, we suspect the following:
1. The ‘baseline last saved date’ is not stored in the Project
Server SQL database as a discreet piece of data.
2. It is likely stored in a BLOB (binary file), and thus is not
available for extraction from the SQL database.
Thank you for you help.
-Kevin