[cisco-voip] Running Reports

[John Huston]

You can try this example from the command line:
 
run sql select * from car:tbl_billing_data where callingPartyNumber='1000'
 
This would show you all of the activity from extension 1000
 


--- On Mon, 12/21/09, Huffman, Tim <thuffman at rosettastone.com> wrote:


From: Huffman, Tim <thuffman at rosettastone.com>
Subject: [cisco-voip] Running Reports
To: "cisco-voip at puck.nether.net" <cisco-voip at puck.nether.net>
Date: Monday, December 21, 2009, 1:03 PM








All,
 
I need to be able to run reports what will tell me all activity from a phone for a date range.  I’m in the CDR Analysis and Reporting tool running CDR -> Search -> By User/Extension.  The extension that I’m using is not giving me any data for the date range when I know for a fact it was being used.  Any other reports I can run, or anything I’m doing wrong?
 
Thanks,
 
Tim Huffman
Rosetta Stone®
Cisco Telephony Administrator
T (540) 236-5077
(800) 788-0822
RosettaStone.com

This e-mail and any attachments thereto are intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail, you are hereby notified that any dissemination, distribution or copying of this email, and any attachments thereto, is strictly prohibited. If you receive this email in error please contact the sender by reply email and destroy all copies of the original message.
 
-----Inline Attachment Follows-----


_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20091221/5758d857/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 1952 bytes
Desc: image001.jpg
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20091221/5758d857/attachment.jpg>