> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Table auditloginevent

> The auditloginevent table records and monitors user login activities in the Zuora system, detailing login history and attributes.

The auditloginevent table records and monitors user login activities in the Zuora system, detailing login history and attributes.

The Zuora system records every login for each user in the `auditloginevent` table and allows you to monitor the login history for each and every user. See the table structure below.

<table>
  <tr>
    <th>
      Attribute
    </th>

    <th>
      Type
    </th>

    <th>
      Description
    </th>
  </tr>

  <tr>
    <td>
      browsertype
    </td>

    <td>
      varchar
    </td>

    <td>
      The login user's browser type. Possible values are:

      * IE
      * FireFox
      * Safari
      * Netscape
      * Chrome
      * Opera
      * Api
      * Unknown
      * RestLogin
      * RestBiz
    </td>
  </tr>

  <tr>
    <td>
      browserversion
    </td>

    <td>
      varchar
    </td>

    <td>
      The login user's browser version
    </td>
  </tr>

  <tr>
    <td>
      createdbyid
    </td>

    <td>
      varchar
    </td>

    <td>
      The login user's id
    </td>
  </tr>

  <tr>
    <td>
      createddate
    </td>

    <td>
      timestamp with time zone
    </td>

    <td>
      The record's creation date
    </td>
  </tr>

  <tr>
    <td>
      day
    </td>

    <td>
      integer
    </td>

    <td>
      The day when the record is created.
    </td>
  </tr>

  <tr>
    <td>
      eventid
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the login event
    </td>
  </tr>

  <tr>
    <td>
      hostname
    </td>

    <td>
      varchar
    </td>

    <td>
      The device connected to the network (currently not work, the value is the same as ipaddress)
    </td>
  </tr>

  <tr>
    <td>
      id
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the record
    </td>
  </tr>

  <tr>
    <td>
      ipaddress
    </td>

    <td>
      varchar
    </td>

    <td>
      The login IP address
    </td>
  </tr>

  <tr>
    <td>
      logintype
    </td>

    <td>
      varchar
    </td>

    <td>
      The login type. Possible values are:

      * CLIENT_CREDENTIALS
      * SSO
      * PASSWORD
      * SWITCH_ENTITY_UI
    </td>
  </tr>

  <tr>
    <td>
      month
    </td>

    <td>
      integer
    </td>

    <td>
      The month when the record is created.
    </td>
  </tr>

  <tr>
    <td>
      sequencenumber
    </td>

    <td>
      bigint
    </td>

    <td>
      The sequence number of the login record
    </td>
  </tr>

  <tr>
    <td>
      status
    </td>

    <td>
      varchar
    </td>

    <td>
      The login status. Possible values are:

      * Success
      * AuthFail
      * PasswordExpired
    </td>
  </tr>

  <tr>
    <td>
      timestamp
    </td>

    <td>
      timestamp with time zone
    </td>

    <td>
      The timestamp of the login
    </td>
  </tr>

  <tr>
    <td>
      tokenid
    </td>

    <td>
      varchar
    </td>

    <td>
      The id of the login token
    </td>
  </tr>

  <tr>
    <td>
      userid\*\*
    </td>

    <td>
      varchar
    </td>

    <td>
      Id of the login user
    </td>
  </tr>

  <tr>
    <td>
      username
    </td>

    <td>
      varchar
    </td>

    <td>
      The user name of the login user
    </td>
  </tr>

  <tr>
    <td>
      year
    </td>

    <td>
      integer
    </td>

    <td>
      The year when the record is created.
    </td>
  </tr>
</table>