Tuesday, March 19, 2013

Cisco CDR delivery failures to billing servers

This is documented all over so I'll skip any narative.  Assume this is just a note to myself....

First location to check for outgoing CDR records by date (03-15-2013):
file list activelog /cm/cdr_repository/preserve/20130315

Locations for records destined for billing servers number 1 and 2
file list activelog /cm/cdr_repository/destination1/20130315
file list activelog /cm/cdr_repository/destination2/20130315

Pull errors via SQL (version 8):
run sql car select count(*) as cnt, error_codes from car:tbl_billing_error group by error_codes order by cnt desc

run sql car select count(*) as cnt, origdevicename from car:tbl_billing_error where datetimeconnect = '0' group by origdevicename order by cnt desc

No comments:

Post a Comment