peripheralNumber of skill group

[Mikhail Kalita]

Good day! How can I find out peripheralNumber of skill group in UCCX 10.6?

[Ritesh Desai]

Hi Mikhail,

Am using UCCE, not UCCX.

Under AWDB and Logger DB, refer to table "skill group" and you shall find 6th column Peripheral Number. Peripheral Number means the skillgroup number known by Peripheral.

You can download the database schema guide

URL: http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_10_6/reference/guide/dbschema.pdf

Regards,

Ritesh Desai.

[Deepak Rawat]

Issue below commands from UCCX CLI to know about all the fields for the tables related to skill

run uccx sql db_cra select * from skill

run uccx sql db_cra select * from skillgroup

Regards

Deepak