09-10-2008 02:52 PM - last edited on 03-25-2019 07:44 PM by ciscomoderator
We have recently upgraded to CCM Ver 6 running the new cisco linux os platform. Previous to this upgrade, we used to have direct access t the MS SQL database and I could view the tables and figure out what is wrong. My first question is, is there a way to access the database (which I think maybe an instance of informix)?
Specifically, my problem is that CAR Department reports are not accurately reporting usage. I have a case open with TAC but am not getting far and we're playing more phone tag than we are doing troubleshooting.
Any insight on the database access or the reporting problems would be appreciated.
Solved! Go to Solution.
09-10-2008 06:03 PM
yes, only thru CLI and limited to QRYs
run sql
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_1_1/cucos/iptpappa.html#wp1052698
download the data dictionary to know the informix DB layout
Programming Guides
http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html
your TAC CSE should already know how to do this
HTH
java
if this helps, please rate
09-10-2008 06:03 PM
yes, only thru CLI and limited to QRYs
run sql
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_1_1/cucos/iptpappa.html#wp1052698
download the data dictionary to know the informix DB layout
Programming Guides
http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html
your TAC CSE should already know how to do this
HTH
java
if this helps, please rate
09-14-2008 10:16 AM
Thanks for the info - I found that the CLI is not limited to only perofrming a query. In fact, in my case, I was able to update all my records that were missing user_id's using the following CLI
The command to update the data is:
run sql update car:tbl_billing_data set user_id='johndoe' where callingpartynumber=1000
Where user_id and callingpartynumber corresponds to my internal user's and their extensions.
09-14-2008 02:44 PM
guess our concept of QRY are not the same
for me a QRY is any SQL statement and not limited to search records, anyway i'm glad you were able to add the info you were missing
HTH
java
if this helps, please rate
09-14-2008 03:45 PM
You're right, I totally read your initial post as meaning QRY was the equiv. of just a select statement. Re-reading and understanding what I know now, your post along with links was exactly what I was looking for - my patience was just not there to review it with a critical eye. Thanks again, I've rated your post.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: