Our PMO would like a report of Project task audit/history information for a group of projects. Other than the project pages, is there anywhere to get this information in PPM? Have any of you created reports or portlets to pull this information? If so, do you have any SQL/JSP you can share? We are using PPM 7.2 SP8.
select a.CREATION_DATE "DATE", u.FULL_NAME "NAME", CASE a.FIELD_ID When 'workUnit.audit.estimatedFinish' Then 'Est Finish Date' When 'workUnit.audit.estimatedRemainingEffort' Then 'Est Effort Rem' End "ITEM CHANGED", a.OLD_VALUE "BEFORE", a.NEW_VALUE "AFTER", a.ENTITY_NAME from ITG_AUDIT_EVENTS a join KNTA_USERS u on u.USER_ID = a.CREATED_BY where 1=1 and a.CONTAINER0_NAME like 'Oracle Implementation%' -- project name and a.CREATED_BY != 30260 -- don't show the PM's activity and a.ENTITY_NAME like '%>%[%]' and a.FIELD_ID in ('workUnit.audit.estimatedRemainingEffort','workUnit.audit.estimatedFinish') and a.CREATION_DATE >= sysdate-5