Activity Logs

As users navigate the system and manipulate forms and perform various actions, we sometimes find that we want to track that information. The built in logging mechanism stores custom activity logs in the database and that information is searchable and reportable for various metrics interesting to management or for auditing purposes.

The Activity Logs admin area is at the url /admin/activity-logs. When navigating to that URL, you'll see a search form along with a list of the most recent activity logs.

You can search by:

• Activity - The specific activity that is being tracked.
• Reference Table - The specific database table that the data relates to.
• Reference ID - The primary key of a referenced entity.
• Date Range - The date of the activity log entry.
• Text Search - Searches activity, notes and data.

Search Results contain a list of the filtered records. If a code icon appears next to a record, click it to see any data that is associated with the log. If a letter envelope appears next to the record, that means an email related to the record was sent to a user. Click that to view email message.

You can click the Export to Excel button (not shown) to export activity logs to a spreadsheet.

Developers will need to manually add things that need to be logged as features are developed. Those activities can be search upon and viewed from here. Here's a partial sample C# code snippet that is adding an activity log record to the database:

var log = new ActivityLog($"Invoice {action}", SecurityHelper.GetUserInfo(User, db).Id, "Invoice", invoice.Id);
db.ActivityLogs.Add(log);
db.SaveChanges();