Tracking User actions

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

Hi Richard 

Thank you very much for the answer...

I just hope I understood your question correctly, user changes made in the runtime part of your solution is a different thing i.e., changing a setpoint value or starting the process.

This is of course covered by the Alarms and Event system and requires a longer explanation, but it is a core part of the System Platform solution.

I just hope I understood your question correctly, user changes made in the runtime part of your solution is a different thing i.e., changing a setpoint value or starting the process.

This is of course covered by the Alarms and Event system and requires a longer explanation, but it is a core part of the System Platform solution.