Contents

Introduction

Prerequisites

Requirements

Components Used

Conventions

Import Users

Identify the Type of Imported Use

AXL Imported Users

Non-AXL Imported Users

LDAP Imported Users

Non-LDAP Imported Users

References

Related Information

Introduction

This document describes how to identify the type of imported user with the use of command-line interface (CLI) commands in Cisco Unity Connection.

In Unity Connection, users can be imported from two sources - Cisco Unified Communications Manager (CUCM) and Active Directory (AD). Users imported from CUCM are known as Administrative XML (AXL) imported users. Users imported from Active Directory are known as Lightweight Directory Access Protocol (LDAP) imported users.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

- Cisco Unity Connection

- Cisco Unified Communications Manager

- Microsoft Active Directory

Components Used

The information in this document is based on these software versions:

- Cisco Unity Connection Release 7.X or later

- Cisco Unified Communications Manager Release 7.X or later

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to the Cisco Technical Tips Conventions for more information on document conventions.

Import Users

If you are an AXL user, refer to Creating Multiple Cisco Unity Connection 8.x User Accounts from Cisco Unified Communications Manager Users.

If you are an LDAP user, refer to Creating User Accounts from LDAP User Data or Changing LDAP Integration Status for Existing Users in Cisco Unity Connection 8.x.

Identify the Type of Imported Use

In order to identify the type of imported user, enter these commands in the CLI:

AXL Imported Users

run cuc dbquery unitydirdb select displayname, dtmfaccessid, ccmid, ccmidtype from vw_subscriber where

ccmid is not null

Non-AXL Imported Users

run cuc dbquery unitydirdb select displayname, dtmfaccessid, ccmid, ccmidtype from vw_subscriber where

ccmid is null

LDAP Imported Users

run cuc dbquery unitydirdb select displayname, dtmfaccessid, ldapccmuserid, ldaptype, ldapccmpkid from

vw_subscriber where ldapccmpkid is not null

Non-LDAP Imported Users

run cuc dbquery unitydirdb select displayname, dtmfaccessid, ldapccmuserid, ldaptype, ldapccmpkid from

vw_subscriber where ldapccmpkid is null

vw_subscriber contains all users that have a voicemail subscription. It includes the user information and the associated voicemail information. A few useful column names that can be included are:

- firstname

- lastname

- alias

- emailaddress

Example:

run cuc dbquery unitydirdb select firstname, lastname, alias from vw_subscriber

Include the where clause in the example as shown in the previous section in order to obtain User type-specific information like LDAP / Non-LDAP / AXL/ Non-AXL users.

In order to get a list of all columns in the vw_subscriber, enter:

show cuc dbview schema unitydirdb vw_subscriber

References

Ccmidtype

- 0 - CCM Enduser, also known as AXL Imported

- 3 - ldap user

- 4 - inactive ldap user; for example, marked inactive in ccm database

Ldapccmpkid

If Ldapccmpkid is not null, the user is LDAP Integrated.

Ldaptype

- 0 - user is not LDAP enabled

- 1 - ldap synchronization enabled

- 2 - ldap authentication enabled

- 3 - ldap is enabled, but temporarily inactive for the user

Related Information