last published in 2007?

R

rebecca

Does anybody know what table and field name is used in the 2007
reporting database for the last published date?

thanks in advance!
 
R

Ray McCoppin

Check out the dbo.MSP_EpmProject_UserView view, it contains most all of the
project fields you will need. But there is not a last published date in the
reporting database. But because data can't get into the reporting database
without a publish and if any data changes in the project a save will occur
before a publish the ProjectModifiedDate will follow the last published date.
The one exeception of this is doing a server side publish (from PWA). There
are also a couple of other fields in this view that may help.
ProjectModifiedRevisionCounter
ProjectCreatedRevisionCounter
ProjectCreatedDate

Hope this helps


--
Ray McCoppin

http://www.randsmanagement.com
Project Server 2007 Archival Tool
SRS gantt charts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My computer will print from ALL other programs except MS publisher 2007 4
Cannot do anything after zooming - Publisher Lite on Mac 0
Grouping Names in Mail Merge 0
sqlite-odbc write conflict 2
Last Modified and Last Published 2
Publisher is filling blank lines with data 2
Cannot see and gantt charts or other displays 0
How can I retrieve date last published for a project? 1

Top