[cisco-voip] Need help with CDR Reports

[Ryan Ratliff]

That error means that there are no calls in the specified search  
range that match your search criteria.

What type of search are you doing?  If you are doing a search for a  
specific user's calls and you know the person made calls during the  
time period you are searching on then most likely those calls are  
getting associated to the wrong user.

CAR has a fun "feature" where it does user lookups based on device  
association (unless the user is specifically noted in the CDR record  
via owner userid).  When it asks the directory for the user that owns  
a given device if the directory returns multiple users CAR just takes  
the first one.   If you have an application user, ie Jtapi, ac, etc  
with a lot of device associations it is very possible that all the  
calls are getting associated to that user.

The best way to verify this is to look in SQL at the ART database in  
the tbl_billing_data table.    A query such as select * from  
tbl_billing_data where user_id like '<userid>' will get you all the  
calls ART knows belong to the user you are searching on.   You can  
also do a select * from tbl_billing_data where charge_to like '<phone  
dn>'  to get all the calls that will show up for a given dn.  Check  
out the user_id column to see what user ART is assigning these calls to.

-Ryan

On Nov 9, 2005, at 1:55 AM, Monika Kapil wrote:

Hi All,

I am facing a problem generating the call reports through cdr analysis
and reporting tool.

I am getting the error: 30023: data is not available for the specified
date range.

Can anyone assist.

Thanks
Monika



Monika Kapil
________________________________

Network Administrator, Information Technology
Evalueserve
Tel: +91 124 251 54400(3122)
www.evalueserve.com


-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of James
Sent: Wednesday, November 09, 2005 11:51 AM
To: CiscosupportUpuck
Subject: [cisco-voip] Need help with cra scripting

I have a script that is running .  But I'm trying to create a db dip.
At this point I'm able to read. Data from the database wth the db read .
What I'm trying to do is a get digit string from callers and then check
it against my db.  If its there in the db then send the caller thru the
script
James D. Grace
System Engineer
CCNP CCNA MCSE MCDBA
Digitel Corp.
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip