Determine if a project plan has been published

[TallyGeo]

How can I determine if and/or when a project plan has been published if I am:

1) The Project Server Administrator

2) A Project Manager

3) A Team Member

Thanks...George

 

[Earl Lewis]

George,

This is a tricky one from what I can tell. When you say "published" are you referring to the version of the plan that you can select from the project server or are you looking for whether the plan has actually been successfully published via the MS Project Spooler?

If it's the latter somewhat more esoteric state of publication I suspect you'll need to dig into the database - not sure right off exactly which table(s) you'd need to hit.

If it's the former, have you looked modifying views in PWA? I've successfully added the "Version" field to a project center view - which is available to anyone that logs into PWA.

Earl
How can I determine if and/or when a project plan has been published if I am:

1) The Project Server Administrator

2) A Project Manager

3) A Team Member

Thanks...George

 

[TallyGeo]

Earl,

I am referreing to Publish through the "Collaborate" function (project
spooler)... Thanks for your reply....

George

 

[Earl Lewis]

George,

To see the last published date for any project you can simply add the Last Published field to a project center view of your choice. Everyone, regardless of role in the project server can see their projects in the project center view.

I didn't even realize it was an available field until you asked about it. Thanks for asking the question.

If you're interested in where this comes from in the database you can find it in the MSP_WEB_PROJECTS table and the WPROJ_LAST_PUB field specifically. This SQL will give you the idea:

SELECT WPROJ_ID, PROJ_NAME, WPROJ_LAST_PUB
FROM MSP_WEB_PROJECTS

Good luck!

Earl
Earl,

I am referreing to Publish through the "Collaborate" function (project
spooler)... Thanks for your reply....

George

 

[TallyGeo]

Earl,

Unfortunatley, Microsoft uses the term published instead of saved relative
to project plans. I'm sure we all deal with this confusion with our
customers. The "Last Published" field really means last saved date. You can
also use the "Last Saved By" field right next to "Last Published" and totally
have everyone confused. Why couldn't Microsoft just say "Saved"....

Anyway, I had tried this previously. I'm still seeking the "Collaborate;
Publish" date, or anything that indicates a plan has been published via
collaboration....once again, thanks for your response...

George