The Audit Logs tile in System Settings provides a read-only record of all data changes made in Sharper. Every time a record is created, updated, or deleted, an entry is automatically written to the audit log. This is useful for tracking staff activity, investigating data discrepancies, and reviewing the history of changes to specific records.
Navigation: System Settings → Audit Logs
Audit Logs are read-only. You cannot edit or delete individual log entries.
Accessing Audit Logs
Navigate to System Settings from the bottom-left navigation pane.
Select the Audit Logs tile.
The audit log list is displayed, showing the most recent changes first.
Example Screenshot - the marina is looking up which user modified a customer.
Open the customer URL to get the audit Entity ID (mymarina.sharpermms.com/crm/customers/16357)
Open the log 'Diff' icon to see what has been modified.
Open the URL for the modified Entity ID - User URL then paste the 'Modified by id' in URL tail (mymarina.sharpermms.com/crm/customers/62)
Refresh url with Entity ID added and record will reveal (User 62 for example)
IMPORTANT: Audit log Entity ID's are different than typical CustomerID, ReservationID, VesselID, UserID. To search audit logs the ID = numerical digits after the URL on a given item.
Example audit log IDs (this applies to most URL's in Sharper):
User log # lookup - open the user settings and check URL for Entity ID:
mymarina.sharpermms.com/system-settings/users/123
Customer log # lookup - open the customer page and check URL for Entity ID:
mymarina.sharpermms.com/crm/customers/123
Invoice log # lookup - open the invoice and check URL for Entity ID:
mymarina.sharpermms.com/crm/invoices/123
EXCEPTION: The URL ID given when looking at a Reservation is NOT what is used in the Audit Log. Reservations are tracked in the Audit Log via the last 5 digits of the Booking ID. This is found by going to Reservations and looking at the "Booking" column. The last 5 digits of this number is what becomes indexed in the Audit Log. See screenhot below:
What Audit Logs Track
Each log entry records:
Field | Description |
Table Name | The record type that was changed (e.g., SdmsInvoice, SdmsReservation, SdmsCustomer). |
Entity ID | The ID of the specific record that was changed. |
DML Type | The type of change: INSERT (record created), UPDATE (record modified), or DELETE (record removed). |
Timestamp | The date and time the change occurred. |
Old Data | The field values before the change (for UPDATE and DELETE operations). |
New Data | The field values after the change (for INSERT and UPDATE operations). |
Common Uses
Investigating a changed invoice or payment — Search for the invoice's entity and ID to see all modifications and who made them.
Tracking who made a change — Log entries capture the user who performed the action.
Recovering accidentally deleted data — The Old Data field shows the values before deletion.
Auditing staff activity — Review changes made by specific users over a time period.
Log Retention
Audit log entries are automatically retained for a minimum of 90 days. Entries older than your company's configured retention period are removed during scheduled maintenance. The retention period is managed by the Sharper implementation team — contact Sharper support if you need to adjust how long audit logs are kept.