none
Project Server 2010 - Read From DB Which tasks are Closed to Update RRS feed

  • Question

  • Hey Everyone,

    Simple question, which table or view can I read in the DBs that shows if a task has been marked Closed to Update?


    120811049008

    Tuesday, July 16, 2013 1:17 PM

Answers

  • Hi,

    You can run the below query on the published database.

    select task_lockdown_by_manager, TASK_NAME from MSP_TASKS where TASK_LOCKDOWN_BY_MANAGER = '1'

    • Marked as answer by Paul MC2 Tuesday, July 16, 2013 2:04 PM
    Tuesday, July 16, 2013 2:03 PM

All replies

  • Hi,

    You can run the below query on the published database.

    select task_lockdown_by_manager, TASK_NAME from MSP_TASKS where TASK_LOCKDOWN_BY_MANAGER = '1'

    • Marked as answer by Paul MC2 Tuesday, July 16, 2013 2:04 PM
    Tuesday, July 16, 2013 2:03 PM
  • OK, published DB it is.

    Thanks a lot for the help


    120811049008

    Tuesday, July 16, 2013 2:04 PM
  • Paul,

    You should not run any query against Published database, Microsoft only supports querying Reporting database

    This information isn't available in the reporting database , so you would need to access this data using the PSI, the field is

    http://msdn.microsoft.com/en-us/library/websvcproject.projectdataset.taskrow.task_lockdown_by_manager_di_pj14mref.aspx

     


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Tuesday, July 16, 2013 7:36 PM
    Moderator
  • Hi,

    Can I update this field using PSI. The Close Task for Update screen in Server requires one to select One Project at a time.The grid is not having Filter, Select All / Sort Options.

    The user wants a more user friendly screen and  fastest way for doing this. Is there any specified steps / process needed to write custom code for this feature.

    Thanks

    Regards,

    Greema


    Greema

    Friday, July 19, 2013 7:15 AM