Finding Tasks with 'Publish' flag set to 'no'

P

PatLac

Hello all,

I'm trying to create a report to list all projects with tasks that have the
'Publish' flag set to 'No'.

It should be easy except that I cannot seem to find the flag in the
MSP_TASKS table. I looked in the Draft and Published database.

Can you help.

Thanks again !
 
P

paul conroy

look for the AssignmentIsPublished column in the MSP_EPMAssignment table in
the reporting DB.
 

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

Similar Threads

Cross-Project Task Links in Project Server 2007 0
Project Server 2007 SP2: Gantt with data in OLAP but not in Published or Draft Databases 0
Create booklet pdf w cover page and inside pages as double spread 1
Completed Tasks and Setting Publish Flag 2
Where is TASK_NOTES in PS 2007 ? 4
PS2007 Reporting Inconsistencies between Timesheet, My Task,Unpublished time, and Published time? 0
ActualFinishDate being set to the same date as FinishDate when markedas complete, regardless of the 0
custom Gantt Views in PS2007 1

Top