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

Audit Trail for Program content

Highlighted
ludo1208
Occasional Advisor

Audit Trail for Program content

Hi,

 

is there any possibility to get an audit trail for the changes of the program content:

That means a changelog when (and who) a proposal or a project was added or deleted from a particular program.

 

I couldn't find anything in the manuals or the data model :-(

 

thanks + regards

Ludo

4 REPLIES
Iliev
HPE Expert

Re: Audit Trail for Program content

Hi Ludo,

 

I cannot find anything about what you are asking about.

 

I found only one old enhancement request that may be related but is not about the same thing http://support.openview.hp.com/selfsolve/document/KM1190203

 

Probably you can open a support case about the functionality that you are asking for.

 

If anyone else has something that I am missing about this - please share it with us.

 

Best Regards,

Iliya

Utkarsh_Mishra
Honored Contributor

Re: Audit Trail for Program content

There is no out of the box way, but you can create a custom solution.

 

Here in my configuration, we don't track the change log, but we trigger a summary notfication at night if any content is added/deleted in a Program.

 

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
ludo1208
Occasional Advisor

Re: Audit Trail for Program content

Hi everybody,

thanks for your replies!
Utkarsh, maybe you can tell me some more details about your solution:
- When you say 'trigger', you don't mean a normal Oracle trigger?
- How did you initiate this summary notification? By PPM means?

thanks + regards
Ludo
Utkarsh_Mishra
Honored Contributor

Re: Audit Trail for Program content

Here we do not have access to Oracle SMTP package, so we notify by java client.

 

We have created a custom table which is similar to Program_content table (also have additional columns about content details) ; daily the nighlty job perform these steps:

 

  1. For first time, load the custom table from the program content table (only for active programs)

Second day onward

 

  1. Check the diference in program content table and custom table (for acive programs only)
  2. based on difference trigger the notification for Program manager
  3. Once notifcations are triggered then agian SYNC the custom table with program content table

This will keep update the program managers; similar approach you can have for audit trail... keep inserting the changes in custom table or probablly you can have trigger on Program content table to insert the changes in custom table.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
//Add this to "OnDomLoad" event