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
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 "ss028955" wrote: > 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
