Published vs. Unpublished Report

[EBaker]

Hello everyone - We have the issue of projects not always getting published,
due to either an error in the publishing process or someone just good old
fashioned forgetting to publish it. Is there a report or other way to know
Projects that have not been published, or where the unpublished hours are
different than the published hours?

If this requires an external report reading directly from SQ that's okay
too, I'm up to the challenge.

Thank You!

Eric Dion Baker

 

[Marc Soester [MVP]]

Hi Eric,

The only way I can see this working is to interrigate the Draft and Publish
Database. All proejcts saved will be in the draft database, all projects
published will be in the publish database. you can run a comparision and this
may does the trick
Hope this helps

 

[Cheri.Phillips]

Hello everyone - We have the issue of projects not always getting published,
due to either an error in the publishing process or someone just good old
fashioned forgetting to publish it.  Is there a report or other way to know
Projects that have not been published, or where the unpublished hours are
different than the published hours?

If this requires an external report reading directly from SQ that's okay
too, I'm up to the challenge.

Thank You!

Eric Dion Baker

This might not be what you want, but for a quick look, you could go to
the Applied Task Update Requests and Errors table (Task Updates | Go
To | Applied Requests and Errors) and give the Published column a
scan. It will show you which task updates have not yet been
published.

Cheri Phillips

 

[Marc Soester [MVP]]

Cheri, htat would only apply to projects which have been published at least
once, otherwise projects would not be displayed in PWA. Sorry to say, but
this is not how you can assertain if a project has been publised or not. The
only way is to compare the draft with the published database.