Querying Unity Connection DB For Alternate Extentions

1. Download User Data Dump Tool:
 Image
2. Install Informix Drivers:
 Image
NOTE:  I had a heck of a time trying to install these 32 bit drivers on my 64 bit WIN7 PC.  I finally gave up and installed
it easily on my XP PRO 32 bit VM.
3. Create PUTTY Session as follows using port 20532:
 Image
4.  Add Remote Administrator Role to GUI Administrator Account:
  1. Go to the Cisco Unity Connection Administration web interface for your installation.
  2. You can leverage a user with or without a mailbox for off box data access purposes, but it’s suggested that you create a new user without a mailbox that is used solely for the purpose of remote administration tasks for security reasons
  3. Be sure the web administration password for this user is not configured to require a change at first login on the “Password Policy” page for that user.
  4. If necessary, change the web administration password on the “Change Password” page.  Note that only the web application password comes into play for remote data access.
  5. Finally, on the “Role” page for the user, add the “Remote Administrator” and the “System Administrator” roles to the “Assigned Roles” list and save.  You can assign any or all other roles as well but for the purposes of remote access to the database and making updates to users those two are necessary.
 Image
5.  Set the Database Proxy Service Shutdown Time
NOTE: For Unit Connection 10.0(1) and later this step is not necessary as there is no longer a Database Proxy Service Shutdown Time.
Out of the box the database proxy service is not running and if you try to start the service it will shut down right away.  First you need to set the “Database Proxy: Service Shutdown Timer” value found in the System Settings -> Advanced -> Connection Administration section of the Cisco Unity Connection Administration page.  By default this is 0.  You can set it to as high as 999 days if you like.  After the number of days configured here the remote database proxy service will shut down.  This is useful if you want to do some migration work, for instance, and don’t want to forget to have the service disabled for security reasons.
NOTE: If you restart the server on versions prior to Unity Connection 10.0(1), the remote database proxy service will remain shut off.  After a system restart you have to go in and manually turn on the service again
 Image
6.  Activate the Remote Database Proxy Service

1.     Out of the box the service that listens to remote database requests is not active, you must turn it on.  To do this, go to the “Cisco Unity Connection Serviceability” web admin page.

2.     On the Tools menu, select the “Service Management” page.

3.     The “Connection Database Proxy” item under the “Optional Services” section will be marked as “Deactivated” and stopped.  Press the “Activate” button and it will be activated and started automatically.

Once you’ve started the proxy service you can connect with any tool that needs off box database access using the user name, web administration password and port “20532”.

NOTE:  For versions of Unity Connection prior to 10.0(1) the service will automatically shut down after the number of days configured in step 2 above or if you restart the server.Image

7. Log into User Data Dump Tool as follows:
Image
When you first start User Data Dump, you will see a login dialog box that will be empty except for port 20532 filled in as the default for the port.  You must provide the server name or IP address for the “Server” field and provide the login and password for the database connection account.  Use the alias and web administration password of the database user created above for the login and password fields.

8.  Browse to a folder to save the CSV output file:
Image
9. Select Add >> Select alias checkbox >> Select Next
Image
10. Select All Alternate Extensions >> Select Next
Image
11. Select Go
Image
12.  View Progress
Image
13.  Upon completion, select “Yes” To View Log File Showing All Users Selected in Step 9
Image
Image
14.  Close Log File and Select Yes to view CSV Output File
Image
15.  View Subscriber Accounts with Alternate Extensions Configured
Image
Advertisements

About Amir Safayan

I live with my family in beautiful Colorado. We have a basset / beagle named Cisco. We board / ski, ride dirtbikes, RV and enjoy living in the Western US. I've done R/S, security, wireless, IPT and am now focused on virtualization technologies on the High Touch Team for Shoregroup.com, a large Cisco reseller.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s