[cisco-voip] Cisco UCCX SQL database

[Anthony Holloway]

It's not something I see everyday, but the following guide has been my go
to piece for when I need to access the UCCX historical data
programmatically.

http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/programming/guide/uccx85hradm.pdf

Specifically, looking at the Before You Begin section on page 4-2, gives
you insight on how to connect to the database.  Don't overlook that
uccxhruser username, as this is really the only place it's documented.

Alternatively, if you simply want to explore the database and its contents,
you can SSH into the UCCX server and run the follow type of commands:

This command gets you a list of all of the columns in the contact call
detail (CCDR) table (basically the CDR table in UCCX)
run uccx sql db_cra select colname from syscolumns where tabid = (select
tabid from systables where tabname = 'contactcalldetail') order by colname
asc

This command gets you the values of records within the CCDR (just replace
with real column names and values)
run uccx sql db_cra select col1, col2, colN from contactcalldetail where
col1 = val1

I hope that helps out.

On Fri, Sep 11, 2015 at 2:46 PM Claiton Campos <claitoncampos at gmail.com>
wrote:

> Does anyone know if it is possible and how to access the tables of uccx
> via sql? I need to extract information from ANI and DNIS to perform an
> integration with
> another system.
>
> Regards.
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20150911/6b9c81c2/attachment.html>