Assignment by day in Published database ? RRS feed

  • Question

  • Hello everyone,

    I have found several times some inconsistencies between the published and reporting database (Project Server 2010), on custom fields and actuals! A backup/restore of custom fields has not fixed my last issue (no error in the queue jobs).

    I would like to build a query to retrieve from the Published database the "Assignment By Day" work and actual work.

    Can someone help me to find this data ? What is the right table ? I have found the assignment table but not the detail By Day, like in the Reporting view.

    Thanks in advance.

    Tuesday, January 27, 2015 9:56 PM

All replies

  • Hi,

    The data is represented in binary format in the published database and it won't be easy to retrieve it with a simple query. I would suggest using PSI/Powershell etc. to extract this data from the published/draft database

    Hope this helps


    Tuesday, January 27, 2015 11:11 PM
  • Hi Paul,

    Thank you for very much your answer.

    It a bad news for me. I would prefer to build a simple SQL query ...


    Friday, January 30, 2015 5:59 PM