cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
161
Views
5
Helpful
1
Replies
Highlighted

Using SQL to retreive/update service parameters in CUCM 11.5

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: Required FieldThis 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.

Everyone's tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Using SQL to retreive/update service parameters in CUCM 11.5

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.

1 REPLY 1
Cisco Employee

Re: Using SQL to retreive/update service parameters in CUCM 11.5

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.

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards