Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

PPM Project Audit History

Highlighted
Scott A. Wood
Super Collector

PPM Project Audit History

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.

Thanks,

Scott
1 REPLY
Erik Cole
Honored Contributor

Re: PPM Project Audit History

Hi Scott,

This is for tasks, but should get you started...

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
//Add this to "OnDomLoad" event