Loading...
Quick Links

Reply To: Project Server 2013 – Status Updates Not Updating Actuals

Home Forums Discussion Project Server 2013 – Status Updates Not Updating Actuals Reply To: Project Server 2013 – Status Updates Not Updating Actuals

#409697
Kevin Jacobs
Guest

Someone might have a better query, but we’ve been using this one to help us see some of the errors.

SELECT
T.ASSN_TRANS_SUBMIT_DATE,
R.ResourceName,
R2.ResourceName as ‘Approver’,
P.PROJ_NAME,
A.TASK_NAME,
IS_PUBLISHED = CASE WHEN P.WPROJ_LAST_PUB > T.ASSN_TRANS_SUBMIT_DATE THEN 1 ELSE 0 END

FROM
PUB.MSP_ASSIGNMENT_TRANSACTIONS T (NOLOCK) LEFT OUTER JOIN
PUB.MSP_ASSIGNMENTS_SAVED A (NOLOCK) ON T.ASSN_UID = A.ASSN_UID LEFT OUTER JOIN
PUB.MSP_PROJECTS P (NOLOCK) ON A.PROJ_UID = P.PROJ_UID JOIN
MSP_EpmResource R ON T.ASSN_TRANS_SUBMITTER_RES_UID = R.ResourceUID JOIN
MSP_EPMResource R2 on T.ASSN_TRANS_APPROVER_RES_UID = R2.ResourceUID

WHERE
T.ASSN_TRANS_ERROR_ENUM =5 AND

T.ASSN_TRANS_SUBMIT_DATE > ‘Jan 1, 2017’