Tracking User actions

Question

Can you help me with a way to determine which changes was done by a specific user after a specific date on System Platform 2017 U3 SP1?

Richard Köhlerstrand · Accepted Answer

Hi Siyaphila. 
 System Platform does not log the exact change, but there is a way to extract the object change log from the galaxy database using the gobject_change_log table. 
 
 But as a start it looks quite crude and you want to modify the query to include at least the Object name. 
 Like so: 
 SELECT gobject_log_details.tag_name, gobject_change_log.gobject_change_log_id, gobject_change_log.gobject_id, gobject_change_log.change_date, gobject_change_log.operation_id, gobject_change_log.user_comment, gobject_change_log.configuration_version, gobject_change_log.user_profile_name FROM gobject_change_log INNER JOIN gobject_log_details ON gobject_change_log.gobject_id = gobject_log_details.gobject_id order by change_date 
 
 As you can see, there is a column with username ( user_profile_name ), this requires you to have security turned on in you galaxy to be able to bind your activity to a specific, in IDE, logged in user. If security is not enabled DefaultUser will be logged. 
 Also this is where you find your check-in comments, In some deliveries I require all check in comments to reefer to a ticket-id, and this makes it easy to link a change to a task/project/specific change. if no comment is entered it will be blank or replaced with a generic text (see list of examples below). 
 Once you have this query you can start to modify it to limit the result based on your need, keep in mind that some check-ins will touch upon derived objects and that activity will be logged here as well. And deploy, check out + undo check-out will be present too. 
 And you might want to group them by Templates, Instances and Symbol changes. 
 But this will at least give you an idea on any development activity that has been executed on your galaxy. 
 The uses of this are many, not only to make your point when all developers are stating that they did not touch a thing 
 But it can be a good source of data for making documentation when you are planning for a release.

And since it is based on a SQL Query you could make it more available using i.e.. reporting services or any other reporting tool. 
 I hope his helps! 
 Richard

Tracking User actions

Top Replies