CUCM SQL Queries for users with IPCC Extension and Primary Extension asigned

Run the following in a CLI session on your CUCM Server to generate a list of users with IPCC extensions assigned in their user profile:

run sql select e.userid, n.dnorpattern from enduser as e, numplan as n, endusernumplanmap as x where (e.pkid = x.fkenduser and x.fknumplan = n.pkid and tkdnusage=2)

Run the following query for users with primary extensions assigned:

run sql select e.userid, n.dnorpattern from enduser as e, numplan as n, endusernumplanmap as x where (e.pkid = x.fkenduser and x.fknumplan = n.pkid and tkdnusage=1)

Getting Cisco Phone Designer working on x64 Windows 7

Have to give credit to the guys on the cisco forums for this tip.  Cisco Phone designer doesn't support x64 Windows 7.  To get it to run:

• Open up command prompt as administrator and type this command:
• C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Ldr64.exe SetWoW
• Now you should be able to run apps that use only the .NET 32 bit CLR

• To revert back to the default 64 bit framework run
• C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Ldr64.exe Set64

Issues with SCCP Phone Registration through a Juniper Netscreen

Deployed an NG5-GT out to a remote site to get a phone up and running behind it via ipsec VPN.  Tested everything locally before deployment and phone registration was all good.  Once shipped to site, the phone wouldn't register.  We'd see attempts to register in CUCM logs but we'd see it marked as 'rejected' and log analysis would show a Transient Connection and Registration Failure.

Ended up switching off the ALG for SCCP (Security > ALG) and the phone registered fine.

Just in case anyone ever has the same issue.

To login and logout of Extension Mobility via a URL:

https://x.x.x.x:8443/emapp/EMAppServlet?device=SEP6400F1111111&&userid=userid&seq=PIN
https://x.x.x.x:8443/emapp/EMAppServlet?device=SEP6400F1111111&doLogout=true

For when your provisioning app hits the craps and you need to do it remotely :).

9971 Phones need at least one DN assigned to register

Yet another knocking head against the wall issue.  We've been running phones without extensions and EM enabled so that users could log in to get their correct Lines.  Came to put a 9971 into production and the phone wouldn't register.  Status message on the screen was simply 'Phone not registered'.

Went through all the debugging steps.  Status messages on the phone showed no obvious issues.  Trust list was being updated successfully.  TFTP load was happening correctly.  Uploaded new firmware to the cluster and the phones pulled it down correctly.  Basic network traces showed the phone booting, doing 3 dns requests, pulling config down via HTTP from the TFTP server (a few requests) and then heading off to the NTP server.  We never saw any SIP requestes (port 5060).

The only thing of real note was this line in the status logs:

7301 NOT 13:25:22.214160 CVM-cfg.line1NotConfigured: [thread=configmgr MQThread][class=cip.cfg.j] sipMinCfgCheck():Line 1 not configured..

After spending a couple of hours on the phone with TAC, managed to narrow the issue down to the phone having no DN assigned.  Assigned a DN and the phone registers fine.

If you hit this issue and are using EM, don't forget to update the EM logout profile on the phone, it takes precedence over the physical phone profile.  If you only update the physical device record and not the Device Profile it won't register.

Hope this saves someone some time.