Uppubish Project report

S

ss028955

I need to write a query for cube which shows List of Project which are not
published yet.

Can someone guide me which table and database I should refer to?

Thanks in Advance
ss028955
 
A

Andrew Jacks

Hi,

The only way i know that you can get a list of un-published Project is from
the Draft Database.

This SQL will give you a list -

SELECT PROJ_UID, PROJ_NAME, WPROJ_LAST_PUB FROM MSP_PROJECTS WHERE
WPROJ_LAST_PUB IS NULL

However getting any data from any of the Project Databases except the
Reporting Database is not reccommended by Microsoft as service packs could
change the structures/use of these columns. So use with CARE!

Have a Good Day
 

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

Top