CMS R21.0.1 and later versions include a Database Change Log feature that tracks and logs all database updates initiated by a logged-in CMS user. The log is in the form of a list of each database QUERY along with date and time.

For example, Fri Oct 11 08:46:27 2024 USER=cmssvc TIME=00:00 STATUS=0 TASK=17 QUERY= update vectors set (rd,wrt,exception) = ( "y","n","n" ) where acd=1 and ((vector = 100)) and uid in (select uid from users where l_name="username" )

Only successful updates are logged. This log helps identify who made a database update and when.

This log is complementary to the qlog (Query log) which logs read access to the database.