Database Activity Log

Database Activity Log

The Database Activity Log report shows a history of updates made to data in the Snap Schedule 365 database during the specified date range. Snap Schedule 365 keeps track of the changes each scheduler makes to the database. Whether you log in/out, create new data records, delete or make changes to existing data, Snap Schedule 365 maintains a database activity log that serves as an audit trail. You can use this log to get answers to questions like "Who logged in from where, when did they log in, and what changes were made?"

Because Snap Schedule 365 is truly a multi-user scheduling software, each entry in the log is time-stamped with the system time of the database server because time clocks on client computers may not be synchronized or computers may be located in different time zone. By default, this report shows the current date's activities up to the time when the report is run.

The report contains the following fields:

Report Header Information: Your business name, report title, the range of dates covered in the report, and the sort order. You can selectively hide these fields using the command.

Application User: The name of the application user who initiated the activity.

Machine Name: The name of the computer where the action was taken.

Date/Time: The date and time (using the database server time clock) when the activity took place.

Activity: The high level operation that took place. Typical operations are: Create, Edit, and Delete.

Entity Name: The object (e.g. database table name) that was affected by the activity.

Record ID: The ID of the record in the object that was affected. This information is useful to Snap Schedule Premium technical staff to drill down to the specific record in the collection.

Description: A brief description of operation performed and/or affected data.