﻿---
title: MySQL Enterprise fields
description: MySQL Enterprise Audit module Fields from MySQL Enterprise Logs Module for parsing MySQL Enterprise Audit Logs 
url: https://www.elastic.co/elastic/docs-builder/docs/2988/reference/beats/filebeat/exported-fields-mysqlenterprise
products:
  - Beats
  - Filebeat
applies_to:
  - Elastic Cloud Serverless: Generally available
  - Elastic Stack: Generally available
---

# MySQL Enterprise fields
MySQL Enterprise Audit module

## mysqlenterprise

Fields from MySQL Enterprise Logs

## audit

<applies-to>
  - Elastic Stack: Beta
</applies-to>

Module for parsing MySQL Enterprise Audit Logs
<definitions>
  <definition term="mysqlenterprise.audit.class">
    A string representing the event class. The class defines the type of event, when taken together with the event item that specifies the event subclass.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.connection_id">
    An integer representing the client connection identifier. This is the same as the value returned by the CONNECTION_ID() function within the session.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.id">
    An unsigned integer representing an event ID.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.connection_data.connection_type">
    The security state of the connection to the server. Permitted values are tcp/ip (TCP/IP connection established without encryption), ssl (TCP/IP connection established with encryption), socket (Unix socket file connection), named_pipe (Windows named pipe connection), and shared_memory (Windows shared memory connection).
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.connection_data.status">
    An integer representing the command status: 0 for success, nonzero if an error occurred.
    type: long
  </definition>
  <definition term="mysqlenterprise.audit.connection_data.db">
    A string representing a database name. For connection_data, it is the default database. For table_access_data, it is the table database.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.connection_data.connection_attributes">
    Connection attributes that might be passed by different MySQL Clients.
    type: flattened
  </definition>
  <definition term="mysqlenterprise.audit.general_data.command">
    A string representing the type of instruction that generated the audit event, such as a command that the server received from a client.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.general_data.sql_command">
    A string that indicates the SQL statement type.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.general_data.query">
    A string representing the text of an SQL statement. The value can be empty. Long values may be truncated. The string, like the audit log file itself, is written using UTF-8 (up to 4 bytes per character), so the value may be the result of conversion.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.general_data.status">
    An integer representing the command status: 0 for success, nonzero if an error occurred. This is the same as the value of the mysql_errno() C API function.
    type: long
  </definition>
  <definition term="mysqlenterprise.audit.login.user">
    A string representing the information indicating how a client connected to the server.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.login.proxy">
    A string representing the proxy user. The value is empty if user proxying is not in effect.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.shutdown_data.server_id">
    An integer representing the server ID. This is the same as the value of the server_id system variable.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.startup_data.server_id">
    An integer representing the server ID. This is the same as the value of the server_id system variable.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.startup_data.mysql_version">
    An integer representing the server ID. This is the same as the value of the server_id system variable.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.table_access_data.db">
    A string representing a database name. For connection_data, it is the default database. For table_access_data, it is the table database.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.table_access_data.table">
    A string representing a table name.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.table_access_data.query">
    A string representing the text of an SQL statement. The value can be empty. Long values may be truncated. The string, like the audit log file itself, is written using UTF-8 (up to 4 bytes per character), so the value may be the result of conversion.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.table_access_data.sql_command">
    A string that indicates the SQL statement type.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.account.user">
    A string representing the user that the server authenticated the client as. This is the user name that the server uses for privilege checking.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.account.host">
    A string representing the client host name.
    type: keyword
  </definition>
  <definition term="mysqlenterprise.audit.login.os">
    A string representing the external user name used during the authentication process, as set by the plugin used to authenticate the client.
    type: keyword
  </definition>
</definitions>