Do you work in an enterprise environment where so many people have access to the same Primavera P6 database? Have you ever wanted to find out who made changes to your Primavera P6 schedule without leaving any comments in a Primavera P6 Notebook?
Here is quick tip to help you track users who made changes to your Primavera P6 schedule.
Add the 4 new fields (columns) to your layout by clicking on the columns icon as shown image No.1 below.
Image No.1
You can also access the columns dialog box by clicking on View menu (highlight 1) and Columns (highlight 2) as shown in image No.2 below.
Image No.2
In the Columns dialog box, expand General category under Available Options by clicking on the left hand side of the dialog box as shown in image No. 3 below.
Image No.3
In the list under General, select the following fields by holding the Control key and clicking on Added By, Added Date, Last Modified By & Last Modified Date as shown in highlight 1 below in image No.4 below.
Then click on the right facing single arrow (highlight 2) so that all selected fields are moved to the right hand side of the dialog box under Selected Options as shown in highlight 3 in image No.4 below.
With the required 4 fields now under Selected Options, click on Apply button (highlight 4 in image No.4) so that they are reflected in your layout and then click on OK button (highlight 5 in image No.4).
Image No.4
The layout you need to track users who make changes to your schedule is now ready as shown in image No.5.
Image No.5
Remember to save your layout.
What if someone deleted something? This layout wouldn’t show you the info on the missing activities. Is there a way to find out in that instance?
This layout will not show you directly in the progress file if someone has deleted something. Also don’t forget the potential effect ‘F9’ (schedule function in P6) can have in some scenarios.
Database monitoring can be used to track change and/or delete items in detail.
Ok, so what is the potential effect of F9?
Thanks
Allison
Please note that the LAST MODIFIED BY is just THAT – the last user to modify that specific record. It will not reveal the previous user(s) to that (i.e. Betty made a modification followed by Tom, followed by Mary. Only Mary will be shown as the Last Modified By)
In order to reveal a record deletion you will need to directly access the SQL database. Almost all tables have the following fields:
create_user (record created by)
create_date (date record was created)
update_user (record last updated by a specific user)
update_date (date record last updated)
delete_session_id (if a record has been deleted, it will show the SESSION ID*)
delete_date (date the record was deleted)
*The SESSION table will have the history of all sessions by Session_ID, the user name for that session, and the session_start and session_end date/times.
The F9 will update/overwrite most of the DATE fields in the TASK table:
early_start_date
early_end_date
late_start_date
late_end_date
and all of the “internal” start/finish dates
Thanks! this is helpful.
How do I directly access the SQL database?
Not so simple to outline here. Hopefully you know some SQL. You’ll have to get an SQL client to connect to the db and write SQL queries to access the data.