How to detect when a project has un-published data

[AaronD]

I know I can add the 'Last Published' date column to the Project
Center view to get a decent idea, however, I'm looking for a more
reliable way to tell when a project has un-published data.

My worry is that until new PMs get used to having to Publish, as well
as Save and Check-In projects after modification, they may forget the
step of Publishing.

I'd like to be able to detect when a Project (or projects) have
unpublished data, so I can query this periodically and check in with
the PM to see if they actually wanted to keep the changes in the draft
DB, or if they just forgot to publish.

I've tried things like

select PROJ_LAST_SAVED,PROJ_NAME,
PROJ_CHECKOUTBY,PROJ_PUBLISH_STATUS
from dbo.MSP_PROJECTS
ORDER BY PROJ_LAST_SAVED;

and

select * from dbo.MSP_PROJECTS_PUBLISHED_VIEW

but wasn't able to tell if there were any field that would tell me if
a project had un-published data ('PROJ_PUBLISH_STATUS' sounded
promising, but it wasn't obvious if this would actually give me what I
need)

Thanks,
Aaron

 

[Gary Chefetz]

Aaron:

You are certainly not going to find that information in the reporting
database as that represents what is published, not what isn't published. I'm
not certain whether you can retrieve this information programmatically, I
think you might be able to, but you should ask that question in the
developer's group.

 

[Ben]

Hi Aaron,
If you are worried about projects remaining unpublished, I have a server
based tool that will publish projects programatically to a schedule. Contact
me if you want more info.