A while ago I set upon configuring a Debian server to use ODBC and PDO to query our CUCCX server for use as a basic wallboard. I got it working and would now like to extend this our CUCM publisher. For CUCCX, the DB Schema document was very valuable because it gave information on the database name as well as a pretty thorough description of the tables. I'm looking for the same information for CUCM. I've read some of the CUCM Data Dictionary, but I still have questions on how to find the relevant information for the DSN.
So, for the CUCCX Wallboard project, one roadblock was in adding the Informix servername to the DSN. There are certain rules, such as hyphens are turned into underscores, etc. For CUCM, I cut to the chase and pulled a db replication trace to look at what Informix server names were being used, but I would like a verification to make sure I am on the right track. Server names seem to prepended with a "g" and the version number of the server seems to be appended as well, so;
Informix server name:
Does this look correct?
Also, for UCCX, there is a default ucchruser account that is used for the purpose of DB queries. What kind of account should I create to do this? What kind of rights role should it have?
What is the database name on CUCM that I can add to the DSN? Is there a document like the UCCX DB Schema doc that I can use? Any help is very much appreciated.
I've been reading up on your posts and been reading some of your posts. Do you have a tutorial on how you configure access to the database by any chance? I'm interesting in connecting to CUCM from PHP, not sure if this is an option.
I spent more time on your site and I must confess it's very cool. Lots of really good information on there. So, update to my query situation; I've figured out the SQL string I should run to get the information I'm looking for;
run sql car select datetimeOrigination, dateTimeConnect, dateTimeDisconnect, callingPartyNumber, finalCalledPartyNumber from tbl_billing_data where finalCalledPartyNumber like 'XXXXX' or callingpartynumber like 'XXXXX' order by datetimeOrigination
I understand that this statement will proabably not do me much good in rendering the information to a web page, but it's a start. I also found some PHP code that will use AXL, a gentleman had posted it here;
I'm not sure what the port 8443 reference is for since it seems to work without it.
So, my guess is that I should be using the second link for CDR queries.
Does the account used in the AXL query only need the Standard AXL API Access role? I seem to be pulling information when my account is using Super User, but not when using an account that only has the Standard AXL API Access role (not sure if I need to add another role to the group). Beyond that, do you have a tutorial on how to put together a SOAP query for this kind of situation?
The short answer is that you don't.... That isn't entirely true while at
the same time it kind of is, but for the most part you don't configure
the softkeys. You enable or disable them via TCL. Here is the long
answer. Be sure to read the whole thing or e...
Topology: IP Phone > Switches > Microsoft NPS setup to forward 802.1x
proxy to > ISE 2.1 patch 3 Authentication: EAP-TLS using Cisco MIC SANs
Phone Models 802.1X support? 802.1x flavor Addtl Comment EAP-MD5 EAP-TLS
Cisco 3905 Y Y N Cisco 6911 Y Y N Cisco ...
This document describe how DST changes and how time changes are
implemented in DST. Daylight Saving Time (DST) is the practice of
setting the clocks forward 1 hour from standard time during the summer
months, and back again in the fall, in order to make b...