01
SQL
Voice Mail Profile SQL Queries
Another Audit Using SQL This one's been on the backburner for a bit considering the audit where my queries were developed was fulfilled in late 2011... but hey, better late than never, right?
CATEGORY NODE
SQL
14 signals classified under SQL.
02
SQL
Verify Trace Levels using SQL on Cisco UC
Elevated Traces are Risky Hey there! I bet you’ve got experience troubleshooting issues in a UC VOS device, like CallManager, UCCX, CER or otherwise… and you’ve likely had to increase trace levels to Detailed because of…
03
SQL
Jabber Video Calling SQL Query
We Need To Know If Video Calling Is Enabled Another day, another query. This time the request was not up for interpretation in terms of 'Can you pull this kind of data from CUCM?' where I can take a look at what might…
04
Unified Communications
Who has Jabber? Where are they?
Who Is Your Father And What Does He Do? The requests just keep coming... and always for a slightly different set of information requiring the combination of multiple SQL queries or the development of a new one if I…
05
Unified Communications
Updating Primary Extensions The Fun Way
How to Update Primary Extensions the Fun Way Today's post covers a workaround turned update method for the 'Primary Extension' field in CUCM's End User Page. We were asked to build out a new DN and assign it to the user…
06
Unified Communications
Bulk Accept and Relay Config Update SQL
Update I've been refreshed by my colleague Mark on the importance of querying for the tables I need, the db structure, and understanding table naming (tbl globaluser [editable] vs vw globaluser [viewable]). After a bit…
07
Unified Communications
CCM Synced End Users -- And How To Delete Them
When You Delete The Parent Before The Child With Cisco's Unified Communications Manager and Unity Connection products we have a few options when it comes to user accounts for both Endpoint/Permissions management, and…
08
Unified Communications
Finding Orphaned Devices & Device Profiles
A New Query Approaches I have to admit, I haven't been doing much SQL work lately as... due to the holidays and other factors... it's been pretty quiet. The occasional phone firmware upgrade here, troubleshooting call…
09
SQL
Dial Plan Dump using SQL
Context I get a lot of reporting requests. It could be for the Home Cluster enablement on a given (or all) End Users on UCM (we have a post for that!) or it could be for a dump of all the dialable numbers in the…
10
SQL
Mobile Agents, CTIOS, & Crashes
Today's Topic Mobile Agents using CTIOS and some crashes. So here's another "Priority 1" or "Sev 1" issue that I troubleshot last week, and oh boy, it was an interesting one.
11
SQL
Check Call Forward Configs Using SQL
How to Check CFWD Configs using SQL Faster There's an SQL query I run against CUCM Pub in instances where a user has call forward enabled and I have a suspicion this is causing the problem, but I don't always want to…
12
Unified Communications
Identifying Static Phone Loads With SQL
What Is Our Mission As part of the process of upgrading phones to new firmware I've formed a habit of verifying if there are any phones of the particular model (or models) that I'm upgrading that have a static phone…
13
Unified Communications
Pulling Device Defaults Like A Pro
What Is Our Mission To pull a list of device defaults (like the Device Device Defaults GUI page) to gather the device default firmware for a set of phones. In this case we are specifically pulling the device defaults…
14
Unified Communications
Home Cluster And Service Profile Check
What Is Our Mission Pull a list of users where Home Cluster (islocaluser) is Enabled (t) only. Do not display if the user does not have Home Cluster enabled (f). We also want to do the following: