account_audit_log

The audit_log table lists modifications which have occurred against an account.

Column name Description Data type
log_time Timestamp of log entry. timestamp without time zone *
account The account UID.

Reference to account.

 integer *
account_audit_log Primary key.

Unique reference number for this log entry.

 integer
company Company configuration.

Reference to company.

integer *
audit_log_code Internal audit log code number. smallint
logging_operator The operator who performed the operation that resulted in this audit entry.

Reference to operator.

 integer *
message The audit message. text *
modified_object If the audit was triggered by a user interface action, this field identifies the object that was modified. text *
property_name If the audit was triggered by a user interface action, this field identifies the individual field which was modified. text *
old_value If the audit was triggered by a user interface action, this is the previous value of the modified field. text *
new_value If the audit was triggered by a user interface action, this is the new value of the modified field. text *
primary_key If the audit was triggered by a user interface action, this is the primary key of the modified object. text *

To find all audit entries for a given date, use a query like this:

SELECT usn(account), message FROM account_audit_log WHERE log_timestamp BETWEEN '2013-3-25 00:00:00' AND '2013-3-25 23:59:59.999';
 

  usn     |                           message
----------+----------------------------------------------------------
2142424577| Operator jennifer@example.com viewed account/subscription
2142424577| Operator noel@inomial.com viewed account/subscription
2142424577| Operator andrewy@example.com viewed account/subscription
2142424585| Operator andrewy@example.com viewed account/subscription