Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

How can I check call detail records in ART database with SQL analyzer?

I can check the detail records in CDR database from SQL query analyzer but nothing show in the ART database even able to generate from the CAR menu.

Since the ART database synchronizing periodically from CDR I think should show the informatoin also.

Advise please,

1 ACCEPTED SOLUTION

Accepted Solutions
Gold

Re: How can I check call detail records in ART database with SQL

Which table are you looking at ?? In ART DB, the table in which the info is stored is Tbl_Billing_Data. Incase this table is not being populated, CDR to ART update is not working. Can u check and confirm if CDR Insert service is running on the Publisher ??

3 REPLIES
Gold

Re: How can I check call detail records in ART database with SQL

Which table are you looking at ?? In ART DB, the table in which the info is stored is Tbl_Billing_Data. Incase this table is not being populated, CDR to ART update is not working. Can u check and confirm if CDR Insert service is running on the Publisher ??

New Member

Re: How can I check call detail records in ART database with SQL

Thanks Mahesh,

I thought Tbl_Dump_CallDetailRecord but increasing Tbl_Billing_Data as you said. just wanted to know how can check the ART database updating the information.

Thanks agian.

Gold

Re: How can I check call detail records in ART database with SQL

The Table Tbl_Load_History would contain information about when the last load from CDR to ART was done.

212
Views
0
Helpful
3
Replies
CreatePlease login to create content