> ## 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.

# MessageHandler table

> Presence and heartbeat of a message handler, should be updated once a minute. Older records are stale

## MessageHandler Table (241)

Presence and heartbeat of a message handler, should be updated once a minute. Older records are stale

## Fields

| Name                      | Description                                                           | Type                            | Nullable |
| ------------------------- | --------------------------------------------------------------------- | ------------------------------- | :------: |
| MessageHandler\_id        | Primary key                                                           | PK                              |    No    |
| uniqueIdentifier          | GUID identifying the handler, generated by the handler when it starts | String(39)                      |    No    |
| machine                   | Machine the handler is running on                                     | String(254)                     |    No    |
| port                      | UDP port this handler is listening on                                 | UInt                            |    No    |
| processIdLow              | Low word of process id of the message handler process                 | UInt                            |    No    |
| processIdHigh             | High word of process id of the message handler process                | UInt                            |    No    |
| role                      | 1 = request, 2 = respond, 4 = route (bitmapped flags)                 | Int                             |    No    |
| registered                | Registered when                                                       | UtcDateTime                     |    No    |
| registered\_associate\_id | Registered by whom                                                    | FK [associate](./associate.mdx) |    No    |
| updated                   | 'heartbeat' that is updated once a minute by the batch task process   | UtcDateTime                     |    No    |
| updated\_associate\_id    | 'heartbeat' that is updated once a minute by the batch task process   | FK [associate](./associate.mdx) |    No    |
| updatedCount              | 'heartbeat' that is updated once a minute by the batch task process   | UShort                          |    No    |

<img src="https://mintcdn.com/superofficeas/zNQa3AO19PFK63SB/media/loc/en/database/tables/MessageHandler.png?fit=max&auto=format&n=zNQa3AO19PFK63SB&q=85&s=d0af6d3008777e98238f9cfdd442a0a9" alt="MessageHandler table relationship diagram" width="458" height="59" data-path="media/loc/en/database/tables/MessageHandler.png" />

## Indexes

| Fields           | Types       | Description |
| ---------------- | ----------- | ----------- |
| uniqueIdentifier | String(39)  | Unique      |
| machine          | String(254) | Index       |

## Relationships

| Table                    | Description                                                        |
| ------------------------ | ------------------------------------------------------------------ |
| [associate](./associate) | Employees, resources and other users - except for External persons |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Execute Event Handlers](/en/api/reference/restful/agent/customerservice_agent/execute-event-handlers.md)
- [Event Handlers Exists](/en/api/reference/restful/agent/customerservice_agent/event-handlers-exists.md)
- [Event Handler Exists](/en/api/reference/restful/agent/customerservice_agent/event-handler-exists.md)
- [Enum EventHandlerType](/en/automation/crmscript/reference/CRMScript.NetServer.EventHandlerType.md)
- [EventHandler](/en/api/archive-providers/reference/eventhandler.md)
- [SuperOffice.WebApi.Data.EventHandlerType](/en/api/reference/webapi/SuperOffice.WebApi.Data.EventHandlerType.md)