Using SQL to retreive/update service parameters in CUCM 11.5

[Juan Gerardo Hernandez]

Hi guys,

I am trying to check the status of a service parameter in for the CCM process, the service parameter is cluster wide but I cannot find the table to query its status.

I am talking about the OPUS codec.

System -> Service Parameters -> Call Manager -> Clusterwide Parameters (System - Location and Region)

OPUS CODEC

Opus Codec Enabled:	This parameter determines whether Cisco Unified Communications Manager allows Opus negotiation for all, some or no devices. Valid values specify Enabled for All Devices, Enabled for All Devices Except Recording-Enabled Devices, or Disabled.
	This is a required field.
	Default: Enabled for All Devices

I am trying to get into the CLI and do:

#run admin select state from codectlb where opus == disabled

but I was trying to find the correct table in the CUCM Data dictionary.

https://d1nmyq4gcgsfi5.cloudfront.net/media/ucm-dd-11-5/index.html

Do you know how can I query its status from the CLI?

Than you.

Juan.

[dstaudt · Accepted solution]

Try:

sql select * from processconfig where paramname = "OpusCodecEnabled"
--------------------------
pkid                                 fkprocessnode                        paramname        tkparam paramvalue tkservice primarydata resettoggle tkreset versionstamp                                    
==================================== ==================================== ================ ======= ========== ========= =========== =========== ======= =============================================== 
0528096c-bae0-47fe-b353-03010b756456 00000000-1111-0000-0000-000000000000 OpusCodecEnabled 3       1          0         t           f           2       0000000000-c7a6c673-7479-46b0-839e-014d3d093963 

Note the special processnode id '00000000-1111-0000-0000-000000000000' which corresponds to 'EnterpriseWideData' for enterprise params.