Save But Not Publish

J

John Horton

Is there an easy way to see what projects are saved but not published. I have
over 100 projects in the server and need to identify any that have not been
published since the last save.
 
J

Jack Dahlgren

I'm not 100% certain, but I think you could check the date difference
between when it was last published vs. when last modified...

-Jack Dahlgren
 
J

James Fraser

I'm not 100% certain, but I think you could check the date difference
between when it was last published vs. when last modified...

-Jack Dahlgren
Click to expand...
From experience, be careful with this approach. I ran into the problem
Click to expand...
that the last modified date in the reporting database is the last
published date. If a PM only saves a project, the reporting database
is not updated.

I think Gary's approach is more reliable.


James Fraser
 
J

John Cello

Here's what I use to populate the administrator's dashboard:

SELECT dbo_MSP_PROJECTS.PROJ_NAME, dbo_MSP_PROJECTS.PROJ_LAST_SAVED,
dbo_MSP_WEB_PROJECTS.WPROJ_LAST_PUB,
IIf([PROJ_LAST_SAVED]<[WPROJ_LAST_PUB],"Current","Needs to be published.") AS
[Current]
FROM dbo_MSP_WEB_PROJECTS INNER JOIN dbo_MSP_PROJECTS ON
dbo_MSP_WEB_PROJECTS.PROJ_ID = dbo_MSP_PROJECTS.PROJ_ID;
 
Top