cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
394
Views
0
Helpful
4
Replies

CAR CCM 6 Issues

rjrii
Level 1
Level 1

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.

1 Accepted Solution

Accepted Solutions

Jaime Valencia
Cisco Employee
Cisco Employee

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

HTH

java

if this helps, please rate

View solution in original post

4 Replies 4

Jaime Valencia
Cisco Employee
Cisco Employee

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

HTH

java

if this helps, please rate

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.

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

HTH

java

if this helps, please rate

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.

Getting Started

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: