---
title: LDAP-User Fields
slug: rdb/essentials-guide/ldap-user-fields
createdAt: 2026-11-05T09:24:42.070Z
---

Reporting Database further separates LDAP-related fields into sets of basic LDAP-related device fields and groups, described below.

## Basic LDAP-User Device Fields: MI\_USER\_LDAP\_ATTR Table

Table: LDAP user attributes

| Name         | Data type                   | Not Null? | Primary key? | Description |
| ------------ | --------------------------- | --------- | ------------ | ----------- |
| etl\_run\_ts | timestamp without time zone | Yes       | No           |             |
| vsp\_id      | integer                     | No        | No           |             |
| device\_id   | bigint                      | No        | No           |             |
| device\_uuid | character varying(64)       | No        | No           |             |
| user\_id     | character varying(128)      | No        | No           |             |
| attr\_name   | character varying(255)      | No        | No           |             |
| attr\_value  | character varying(640)      | No        | No           |             |

## LDAP-Group Device Fields: MI\_USER\_LDAP\_GROUP Table

*Table 8. LDAP user groups*

| Name         | Data type                   | Not Null? | Primary key? | Description |
| ------------ | --------------------------- | --------- | ------------ | ----------- |
| etl\_run\_ts | timestamp without time zone | Yes       | No           |             |
| vsp\_id      | integer                     | No        | No           |             |
| device\_id   | bigint                      | No        | No           |             |
| device\_uuid | character varying(64)       | No        | No           |             |
| user\_id     | character varying(128)      | No        | No           |             |
| dn           | character varying(640)      | No        | No           |             |
| name         | character varying(128)      | No        | No           |             |

