[cisco-voip] Running Reports
Huffman, Tim
thuffman at rosettastone.com
Mon Dec 21 15:10:54 EST 2009
Thanks for the response John, when I did this, this is all of the info I received. Any other ideas?
admin:run sql select * from car:tbl_billing_data where callingPartyNumber='XXXX'
cdrrecordtype globalcallid_callmanagerid globalcallid_callid origlegcallidentifi er datetimeorigination orignodeid origspan origipaddr callingpartynumber calling partyunicodeloginuserid origcause_location origcause_value origprecedencelevel o rigmediatransportaddress_ip origmediatransportaddress_port origmediacap_payloadc apability origmediacap_maxframesperpacket origmediacap_g723bitrate origvideocap_ codec origvideocap_bandwidth origvideocap_resolution origvideotransportaddress_i p origvideotransportaddress_port origrsvpaudiostat origrsvpvideostat destlegiden tifier destnodeid destspan destipaddr originalcalledpartynumber finalcalledparty number finalcalledpartyunicodeloginuserid destcause_location destcause_value des tprecedencelevel destmediatransportaddress_ip destmediatransportaddress_port des tmediacap_payloadcapability destmediacap_maxframesperpacket destmediacap_g723bit rate destvideocap_codec destvideocap_bandwidth destvideocap_resolution destvideo transportaddress_ip destvideotransportaddress_port destrsvpaudiostat destrsvpvid eostat datetimeconnect datetimedisconnect lastredirectdn pkid originalcalledpart ynumberpartition callingpartynumberpartition finalcalledpartynumberpartition las tredirectdnpartition duration origdevicename destdevicename origcallterminationo nbehalfof destcallterminationonbehalfof origcalledpartyredirectonbehalfof lastre directredirectonbehalfof origcalledpartyredirectreason lastredirectredirectreaso n destconversationid globalcallid_clusterid joinonbehalfof comment seq_id load_i d charge_to user_id manager_id charge call_classification call_type datetimestam porigination datetimestampconnect datetimestampdisconnect orignumberpacketssent orignumberoctetssent orignumberpacketsreceived orignumberoctetsreceived orignumb erpacketslost origjitter origlatency origquality_of_service destnumberpacketssen t destnumberoctetssent destnumberpacketsreceived destnumberoctetsreceived destnu mberpacketslost destjitter destlatency destquality_of_service authcodedescriptio n authorizationlevel clientmattercode origdtmfmethod destdtmfmethod origvarvqmet rics destvarvqmetrics callsecuredstatus origconversationid origmediacap_bandwidt h destmediacap_bandwidth authorizationcodevalue outpulsedcallingpartynumber outp ulsedcalledpartynumber origipv4v6addr destipv4v6addr
============= ========================== =================== =================== == =================== ========== ======== ========== ================== ======= ======================= ================== =============== =================== = =========================== ============================== ===================== ========= =============================== ======================== ============= ===== ====================== ======================= =========================== = ============================== ================= ================= =========== ====== ========== ======== ========== ========================= ================ ====== ================================== ================== =============== === ================ ============================ ============================== === =========================== =============================== ==================== ==== ================== ====================== ======================= ========= =================== ============================== ================= =========== ====== =============== ================== ============== ==== ================== ================ =========================== =============================== === ==================== ======== ============== ============== ==================== ========= ============================= ================================= ====== ======================== ============================= ========================= = ================== ====================== ============== ======= ====== ====== = ========= ======= ========== ====== =================== ========= ============ ============ ==================== ======================= ===================== ==================== ========================= ======================== ======== ============= ========== =========== ====================== ==================== = ==================== ========================= ======================== ====== =============== ========== =========== ====================== ================== = ================== ================ ============== ============== ============ ==== ================ ================= ================== ===================== = ====================== ====================== =========================== ==== ====================== ============== ==============
Tim Huffman
Rosetta Stone®
Cisco Telephony Administrator
T (540) 236-5077
(800) 788-0822
RosettaStone.com
[cid:image001.jpg at 01CA824F.CA564880]
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.
From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of John Huston
Sent: Monday, December 21, 2009 2:56 PM
To: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Running Reports
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
[cid:image001.jpg at 01CA824F.CA564880]
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<http://us.mc800.mail.yahoo.com/mc/compose?to=cisco-voip@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/a71c4665/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/a71c4665/attachment.jpg>
More information about the cisco-voip
mailing list