[cisco-voip] Query CAR Table directly in ccm > 5

[Wes Sisk]

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, import etc.)
>
> many thanks
> regards
> bernhard
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>