Category: Call Manager

Cisco 8851 Partial Registered in CUCM

I’ve got a few Cisco 8851 phones that always come up as partial registered. I understand that partial registered usually means that one or more lines are unregistered or something to that effect. No matter how many times I reset remotely or power cycle the damn thing, it always come back as partial registered. To the users, everything is normal. Everything is normal so – meh. A few weeks later, got an aha moment.

Here’s what I forgot: our users use extension mobility and their device profiles were based on Cisco 7962 or 7965 device types and have all 6 lines associated with a directory number. Cisco 8800-series desk phones without a key expansion module (a.k.a sidecar) can only associate up to 5 lines. The user’s device profiles also have all 6 lines populated and after I disassociate that 6th line from the profile, things are back to normal. Well, it was already normal but you know what I mean.

Filed under: Call Manager, Cisco

UCCX Basic SQL Query

Most of the things that matter daily in UCCX 8.x, 9.x and perhaps 10.x are mostly done in CCX Administration (appadmin) and some troubleshooting done CCX Editor. There is one thing that Report Summary and User View did not do for me: List all users, along with their login ID‘s, and IPCC extensions so I can inform the Windows server team which users belong in the call center.

My solution was to do a SQL query. For those of you who are familiar with MySQL syntax, you will like this or roll your eyes on how easy it is and how unnecessary this post would be. My problem was that I did not know the name of the database and tables the agent info are stored.

See that * in the query below? Don’t do that if you have a lot of agents.


run uccx sql db_cra select * from resource

Or do it anyway to find out the names of the table columns so you can narrow down your search; but do it for one user.


run uccx sql db_cra select * from resource where resourceloginid like 'elton'

Be specific with the table columns instead.


run uccx sql db_cra select resourceloginid,extension,resourcename from resource where active!='f'

I use PuTTY and automatically log all session output so I don’t have to selectively highlight text to copy. Open the directory where you store the logs, open in Notepad++, copy, paste in Excel or Calc.

This is based on the UCCX 9.0 CLI Reference Guide:
http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_0/configuration/guide/UCCX_BK_C940F879_00_cli-reference-guide-for-uccx/UCCX_BK_C940F879_00_cli-reference-guide-for-uccx_chapter_00.html#UCCX_TP_CFB67B78_00

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_02/configuration/guide/UCCX_BK_C007B99C_00_cli-reference-guide-release-902/UCCX_BK_C54B77AG_00_cli-reference-guide-902_chapter_0100.html#UCCX_TP_R1EEC0AE_00

As for SQL queries in Call Manager, check these out:
http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html

Here’s a SQL user lookup example equivalent to viewing info in User Management > End Users


run sql select* from enduser where userid='elton'

William Bell has excellent CUCM SQL query tutorials as well. Don’t forget to check out the comment threads.
http://www.ucguerrilla.com/search/label/Query_Series

Basically, still using standard SQL syntax (yeah, that sounds redundant) prepended by “run sql” but it is just a matter of finding out the table and column names.

Here’s a SQL query to view them.


run sql select x.tabname, y.colname from systables x, syscolumns y where x.tabid=y.tabid order by x.tabname

Filed under: Call Manager, Cisco, Contact Center

Call Forward All “Your call cannot be completed as dialed.” in Call Manager

Consider the scenario:
Long distance route pattern is 9.1[2-9]XX[2-9]XXXXXX
User has a Cisco IP Phone 7975 and wants to divert or forward all incoming calls to a mobile number.
IP phone is configured with a CSS that has access to long distance calls
IP phone’s line configuration has CSS set to

Problem: When the user attempts to set up CFwdAll, after dialing 9 then 1, it immediately yields “Your call cannot be completed as dialed.”

Troubleshooting: Updated line configuration to CSS that can access long distance calls.
Result: Still not able to setup CFwdAll.

Resolution:
Under System, go to Service Parameters and select your server.
For Service, select Cisco Call Manager (Active) from the drop-down menu.
Scroll down to Clusterwide Parameters (Feature – Forward)
By default, the CFA CSS Activation Policy is set to With Configured CSS. Change that to With Activating Device/Line CSS.

Explation: Excerpt from https://supportforums.cisco.com/discussion/11948691/callfwdall-activating-deviceline-css
Three possible values exist for this option:

  • Use System Default
  • With Configured CSS
  • With Activating Device/Line CSS

If you select the With Configured CSS option, the Forward All Calling Search Space that is explicitly configured in the Directory Number Configuration window controls the forward all activation and call forwarding. If the Forward All Calling Search Space is set to None, no CSS gets configured for Forward All. A forward all activation attempt to any directory number with a partition will fail. No change in the Forward All Calling Search Space and Secondary Calling Search Space for Forward All occurs during the forward all activation.

If you prefer to utilize the combination of the Directory Number Calling Search Space and Device Calling Search Space without explicitly configuring a Forward All Calling Search Space, select With Activating Device/Line CSS for the Calling Search Space Activation Policy. With this option, when Forward All is activated from the phone, the Forward All Calling Search Space and Secondary Calling Search Space for Forward All automatically gets populated with the Directory Number Calling Search Space and Device Calling Search Space for the activating device.

With this configuration (Calling Search Space Activation Policy set to With Activating Device/Line), if the Forward All Calling Search Space is set to None, when forward all is activated through the phone, the combination of Directory Number Calling Search Space and activating Device Calling Search Space gets used to verify the forward all attempt.

If you configure the Calling Search Space Activation Policy to Use System Default, then the CFA CSS Activation Policy cluster-wide service parameter determines which Forward All Calling Search space will be used. If the CFA CSS Activation Policy service parameter gets set to With Configured CSS, then Forward All Calling Search Space and Secondary Calling Search Space for Forward All will be used for Call Forwarding. If CFA CSS Activation Policy service parameter gets set to With Activating Device/Line CSS, then Forward All Calling Search Space and Secondary Calling Search Space for Forward All will be automatically populated with the Directory Number Calling Search Space and Device Calling Search Space for the activating device.

Filed under: Call Manager, Cisco

Call Manager LDAP new user ID not synced

Recently changed a user ID in Microsoft Active Directory and performed a full sync but the old user ID has not updated. It was noticed that while performing a full sync, it was done within 5 seconds. With both LDAP synchronization and LDAP authentication set in Call Manager, a user will not be able to log in to Extension Mobility.

To fix the issue:

Navigate to Cisco Unified Serviceability
Under Tools, select Control Center - Feature Services
Under Directory Services, select the Cisco DirSync radio button and click restart.

Navigate back to Cisco Unified CM Administration
Under LDAP, LDAP Directory, select your server and click Perform Full Sync Now
You should notice that synchronization process is taking a bit longer because the Cancel Sync Process button is available.
After the sync process is complete, check if the new user ID is reflected.

If this issue affects Cisco Unified Presence, the service that you need to restart is the Cisco UP Sync Agent.

Filed under: Call Manager, Cisco