|
Home > Archive > Voice over IP Cisco > January 2008 > Query CAR Table directly in ccm > 5
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Query CAR Table directly in ccm > 5
|
|
| Bernhard Albler 2008-01-03, 7:11 pm |
| Dear all,
Maybe someone knows:
is there some twisted way to query the CAR DB inside of ccm 5? I would like to do some queries, which are a pain to replicate in the CAR gui, but which would be extremely easy when using sql directly.
If I do a run sql select * from systables on the cli, no CAR table turns up, so I assume it is the same situation as in CCM4 and CCM Config and CDR are different DBs. Is there some way to access the Data the CAR GUI uses via SQL? (without exporting, impor
t etc.)
many thanks
regards
bernhard
| |
| Wes Sisk 2008-01-03, 7:11 pm |
| This was covered earlier this week on this list. Please have a look at
the archives. /Wes
Bernhard Albler wrote:
> Dear all,
>
> Maybe someone knows:
> is there some twisted way to query the CAR DB inside of ccm 5? I would like to do some queries, which are a pain to replicate in the CAR gui, but which would be extremely easy when using sql directly.
>
> If I do a run sql select * from systables on the cli, no CAR table turns up, so I assume it is the same situation as in CCM4 and CCM Config and CDR are different DBs. Is there some way to access the Data the CAR GUI uses via SQL? (without exporting, imp
ort etc.)
>
> many thanks
> regards
> bernhard
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
| |
| Wes Sisk 2008-01-03, 7:11 pm |
| Hi Bernard,
I just realized you asked the previous question, so something clearly is
missing. Here is a complete example from my lab:
admin:run sql select count(*) as cnt, error_code from
car:tbl_error_id_map group by error_code order by cnt desc
cnt error_code
======= ==========
1944547 31110
1944547 31148
note the use of car: to indicate the CAR database. Otherwise if you are
on 5.0 version of CM beware of
CSCse72987 root access required to access CAR database; no access from CLI
This affects all of 5.0 and is only resolved in CM5.1 and later.
/Wes
Bernhard Albler wrote:
> Dear all,
>
> Maybe someone knows:
> is there some twisted way to query the CAR DB inside of ccm 5? I would like to do some queries, which are a pain to replicate in the CAR gui, but which would be extremely easy when using sql directly.
>
> If I do a run sql select * from systables on the cli, no CAR table turns up, so I assume it is the same situation as in CCM4 and CCM Config and CDR are different DBs. Is there some way to access the Data the CAR GUI uses via SQL? (without exporting, imp
ort etc.)
>
> many thanks
> regards
> bernhard
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
|
|
|
|
|