> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# log_events table

> System log

## log\_events Table (364)

System log

## Fields

| Name               | Description                                                                  | Type     | Nullable |
| ------------------ | ---------------------------------------------------------------------------- | -------- | :------: |
| id                 | Primary key                                                                  | PK       |    No    |
| time\_of\_event    | When did the event take place                                                | DateTime |    Yes   |
| event\_type        | Notification=1, warning=2, error=3, critical error=4                         | Int      |    Yes   |
| event\_group       | See NewLog::EventGroup                                                       | Int      |    Yes   |
| event\_id          | See NewLog::EventId                                                          | Int      |    Yes   |
| target\_id         | The id of the target entity (ticket.id, customer.id etc)                     | Int      |    Yes   |
| var1               | Dynamic info                                                                 | Clob     |    Yes   |
| var2               | Dynamic info                                                                 | Clob     |    Yes   |
| var3               | Dynamic info                                                                 | Clob     |    Yes   |
| var4               | Dynamic info                                                                 | Clob     |    Yes   |
| var5               | Dynamic info                                                                 | Clob     |    Yes   |
| source\_user       | The user generating the event. 1=system, other=ejuser.id                     | Int      |    Yes   |
| source\_user\_desc | Describing the id in source\_user. eg user name or customer name or (System) | Clob     |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/log_events.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=9672572c309142996c819282ac6e5701" alt="log_events table relationship diagram" width="108" height="59" data-path="media/loc/en/database/tables/log_events.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Enum LogEvent](/en/automation/crmscript/reference/CRMScript.NetServer.LogEvent.md)
- [Enum values for LogEvent](/en/database/tables/enums/logevent.md)
- [SuperOffice.WebApi.Data.LogEvent](/en/api/reference/webapi/SuperOffice.WebApi.Data.LogEvent.md)
- [SuperOffice.WebApi.Data.TargetRevision](/en/api/reference/webapi/SuperOffice.WebApi.Data.TargetRevision.md)
- [metering_log table](/en/database/tables/metering-log.md)
- [log_debug table](/en/database/tables/log-debug.md)