Difference between revisions of "SMDR"

From IPitomy Wiki
Jump to navigation Jump to search
 
m
Line 1: Line 1:
http://ipitomy.com/webrelease/IPitomy/IP1100+/SMDR.pdf
+
To download the pdf go here:
  
SMDR data from server<br/>The SMDR data tis outputted from the Reporting->Reports Page. (the export button will only give you a CDR-summary). The file should be polled by directly by calling [ip address]/ippbx/exportCSV.php . By default it will give you all completed calls that day, in SMDR format. <br/><br/>To specify a range of times, you can use the get variables ‘etime’ and ‘stime’. If you provide an stime, it will give you all records from that time until the current time. If you specify both, it will give you<br/>records between those times.
+
[http://ipitomy.com/webrelease/IPitomy/IP1100+/SMDR.pdf http://ipitomy.com/webrelease/IPitomy/IP1100+/SMDR.pdf]
 +
 
 +
SMDR data from server<br/>The SMDR data tis outputted from the Reporting->Reports Page. (the export button will only give you a CDR-summary). The file should be polled by directly by calling [ip address]/ippbx/exportCSV.php . By default it will give you all completed calls that day, in SMDR format.<br/><br/>To specify a range of times, you can use the get variables ‘etime’ and ‘stime’. If you provide an stime, it will give you all records from that time until the current time. If you specify both, it will give you<br/>records between those times.
  
 
The SMDR specification<br/><br/>Example:<br/>[ip address]/ippbx/exportCSV.php?stime=[epoch]
 
The SMDR specification<br/><br/>Example:<br/>[ip address]/ippbx/exportCSV.php?stime=[epoch]
Line 7: Line 9:
 
{| style="width:771px" align="center" border="0" cellpadding="0" cellspacing="0" width="771"
 
{| style="width:771px" align="center" border="0" cellpadding="0" cellspacing="0" width="771"
 
|-
 
|-
| style="width:99px; height:17px" nowrap="nowrap" |  
+
| style="width:99px; height:17px" nowrap="nowrap" |  
 
== Start Time ==
 
== Start Time ==
  
| style="width:99px; height:17px" nowrap="nowrap" |  
+
| style="width:99px; height:17px" nowrap="nowrap" |  
 
== End Time ==
 
== End Time ==
  
| style="width:77px; height:17px" nowrap="nowrap" |  
+
| style="width:77px; height:17px" nowrap="nowrap" |  
 
== Direction ==
 
== Direction ==
  
| style="width:74px; height:17px" nowrap="nowrap" |  
+
| style="width:74px; height:17px" nowrap="nowrap" |  
 
== Trunk ==
 
== Trunk ==
  
| style="width:130px; height:17px" |  
+
| style="width:130px; height:17px" |  
 
== Call ID ==
 
== Call ID ==
  
| style="width:99px; height:17px" nowrap="nowrap" |  
+
| style="width:99px; height:17px" nowrap="nowrap" |  
 
== Source ==
 
== Source ==
  
| style="width:99px; height:17px" nowrap="nowrap" |  
+
| style="width:99px; height:17px" nowrap="nowrap" |  
 
== Source CID ==
 
== Source CID ==
  
| style="width:93px; height:17px" nowrap="nowrap" |  
+
| style="width:93px; height:17px" nowrap="nowrap" |  
 
== Source Channel ==
 
== Source Channel ==
  
 
|-
 
|-
| style="width:99px; height:17px" nowrap="nowrap" |  
+
| style="width:99px; height:17px" nowrap="nowrap" |  
 
1264086258
 
1264086258
  
| style="width:99px; height:17px" nowrap="nowrap" |  
+
| style="width:99px; height:17px" nowrap="nowrap" |  
 
1264086296
 
1264086296
  
| style="width:77px; height:17px" nowrap="nowrap" |  
+
| style="width:77px; height:17px" nowrap="nowrap" |  
 
Incoming
 
Incoming
  
| style="width:74px; height:17px" nowrap="nowrap" |  
+
| style="width:74px; height:17px" nowrap="nowrap" |  
 
DAHDI/1-1
 
DAHDI/1-1
  
| style="width:130px; height:17px" |  
+
| style="width:130px; height:17px" |  
 
1264086247.6308
 
1264086247.6308
  
| style="width:99px; height:17px" nowrap="nowrap" |  
+
| style="width:99px; height:17px" nowrap="nowrap" |  
 
7145554445
 
7145554445
  
| style="width:99px; height:17px" nowrap="nowrap" |  
+
| style="width:99px; height:17px" nowrap="nowrap" |  
 
7145554445
 
7145554445
  
| style="width:93px; height:17px" nowrap="nowrap" |  
+
| style="width:93px; height:17px" nowrap="nowrap" |  
 
DAHDI/1-1
 
DAHDI/1-1
  
Line 62: Line 64:
 
{| style="width:675px" align="center" border="0" cellpadding="0" cellspacing="0" width="675"
 
{| style="width:675px" align="center" border="0" cellpadding="0" cellspacing="0" width="675"
 
|-
 
|-
| style="width:129px; height:32px" nowrap="nowrap" |  
+
| style="width:129px; height:32px" nowrap="nowrap" |  
 
== Destination ==
 
== Destination ==
  
| style="width:122px; height:32px" nowrap="nowrap" |  
+
| style="width:122px; height:32px" nowrap="nowrap" |  
 
== Destination CID ==
 
== Destination CID ==
  
| style="width:171px; height:32px" nowrap="nowrap" |  
+
| style="width:171px; height:32px" nowrap="nowrap" |  
 
== Destination Channel ==
 
== Destination Channel ==
  
| style="width:99px; height:32px" nowrap="nowrap" |  
+
| style="width:99px; height:32px" nowrap="nowrap" |  
 
== DID ==
 
== DID ==
  
| style="width:153px; height:32px" nowrap="nowrap" |  
+
| style="width:153px; height:32px" nowrap="nowrap" |  
 
== Ring Group ==
 
== Ring Group ==
  
 
|-
 
|-
| style="width:129px; height:32px" nowrap="nowrap" |  
+
| style="width:129px; height:32px" nowrap="nowrap" |  
 
Elaine Blodgett
 
Elaine Blodgett
  
| style="width:122px; height:32px" nowrap="nowrap" |  
+
| style="width:122px; height:32px" nowrap="nowrap" |  
 
&nbsp;
 
&nbsp;
  
| style="width:171px; height:32px" nowrap="nowrap" |  
+
| style="width:171px; height:32px" nowrap="nowrap" |  
 
SIP/2208
 
SIP/2208
  
| style="width:99px; height:32px" nowrap="nowrap" |  
+
| style="width:99px; height:32px" nowrap="nowrap" |  
 
9413062200
 
9413062200
  
| style="width:153px; height:32px" nowrap="nowrap" |  
+
| style="width:153px; height:32px" nowrap="nowrap" |  
 
rg_33
 
rg_33
  
Line 97: Line 99:
 
{| style="width:679px" align="left" border="0" cellpadding="0" cellspacing="0" width="679"
 
{| style="width:679px" align="left" border="0" cellpadding="0" cellspacing="0" width="679"
 
|-
 
|-
| style="width:109px; height:24px" |  
+
| style="width:109px; height:24px" |  
 
== Hold Time ==
 
== Hold Time ==
  
| style="width:84px; height:24px" nowrap="nowrap" |  
+
| style="width:84px; height:24px" nowrap="nowrap" |  
 
== Status ==
 
== Status ==
  
| style="width:123px; height:24px" nowrap="nowrap" |  
+
| style="width:123px; height:24px" nowrap="nowrap" |  
 
== Total Call Length ==
 
== Total Call Length ==
  
| style="width:92px; height:24px" |  
+
| style="width:92px; height:24px" |  
 
== Final Entry ==
 
== Final Entry ==
  
| style="width:115px; height:24px" |  
+
| style="width:115px; height:24px" |  
 
== Account Code ==
 
== Account Code ==
  
| style="width:155px; height:24px" |  
+
| style="width:155px; height:24px" |  
 
== Authorization Code ==
 
== Authorization Code ==
  
 
|-
 
|-
| style="width:109px; height:19px" |  
+
| style="width:109px; height:19px" |  
 
3
 
3
  
| style="width:84px; height:19px" nowrap="nowrap" |  
+
| style="width:84px; height:19px" nowrap="nowrap" |  
 
TRANSFERRED
 
TRANSFERRED
  
| style="width:123px; height:19px" nowrap="nowrap" |  
+
| style="width:123px; height:19px" nowrap="nowrap" |  
 
35
 
35
  
| style="width:92px; height:19px" |  
+
| style="width:92px; height:19px" |  
 
&nbsp;
 
&nbsp;
  
| style="width:115px; height:19px" |  
+
| style="width:115px; height:19px" |  
 
&nbsp;
 
&nbsp;
  
| style="width:155px; height:19px" |  
+
| style="width:155px; height:19px" |  
 
&nbsp;
 
&nbsp;
  
Line 193: Line 195:
 
*Transferred: Connected call successfully transferred.
 
*Transferred: Connected call successfully transferred.
 
*Busy: Call out a trunk returned busy status, or extension was busy.
 
*Busy: Call out a trunk returned busy status, or extension was busy.
*- : Defines the call is still active, and the status will update when completed. Click on the call record for details.
+
*-&nbsp;: Defines the call is still active, and the status will update when completed. Click on the call record for details.
 
*Exited Empty Queue: Call to Queue that follows Exit Empty rule.
 
*Exited Empty Queue: Call to Queue that follows Exit Empty rule.
 
*Exited With Key: Call to Queue that follows the Exit Menu key press.
 
*Exited With Key: Call to Queue that follows the Exit Menu key press.

Revision as of 21:03, 22 January 2013

To download the pdf go here:

http://ipitomy.com/webrelease/IPitomy/IP1100+/SMDR.pdf

SMDR data from server
The SMDR data tis outputted from the Reporting->Reports Page. (the export button will only give you a CDR-summary). The file should be polled by directly by calling [ip address]/ippbx/exportCSV.php . By default it will give you all completed calls that day, in SMDR format.

To specify a range of times, you can use the get variables ‘etime’ and ‘stime’. If you provide an stime, it will give you all records from that time until the current time. If you specify both, it will give you
records between those times.

The SMDR specification

Example:
[ip address]/ippbx/exportCSV.php?stime=[epoch]

Start Time

End Time

Direction

Trunk

Call ID

Source

Source CID

Source Channel

1264086258

1264086296

Incoming

DAHDI/1-1

1264086247.6308

7145554445

7145554445

DAHDI/1-1

 

Destination

Destination CID

Destination Channel

DID

Ring Group

Elaine Blodgett

 

SIP/2208

9413062200

rg_33

Hold Time

Status

Total Call Length

Final Entry

Account Code

Authorization Code

3

TRANSFERRED

35

 

 

 






Field Specification

 

Start Time to End Time is the total length of the call.                                 Epoch Time

                Direction is the direction the call in coming Incoming, Outgoing, or Internal

                 Trunk is the associated inbound/outbound trunk                                 (SIP/ or DAHDI/ or IAX/)

                Call ID                                   The call id of the parent call entry (ties multiple legs of a call together

                Source                                   The Nickname the PBX gives the Source      

                Source Caller ID                  The Caller ID of the Source

                Source Channel                   The Channel of the Source caller

                         Destination                   The Nickname the PBX gives the Destination

         Destination Caller ID                  The Caller ID of the Destination

         Destination Channel                  The Channel of the Destination caller  

                                       DID                   The DID the Call came in on (if applicable)

               

               Ring Group Name                   If it is sent into a ring group, the name of that ring group.

                             Hold Time                   The amount of time the party was waiting for an Agent

Status

  • Abandoned: Call entered a Queue, but the caller hung up before the call was answered or met the failover requirement.
  • ChanUnavail: No channel was able to be created for the call due to a possible error state for the intended destination.
  • Agent Completed: Connected Queue call was terminated at the extension.
  • Hangup: Call to a Menu, but the caller hung up before taking any actions.
  • Caller Completed: Connected Queue call was terminated at the calling parties end.
  • Cancel: Call from an Extension, but the caller hangs up before the call is connected.
  • Answer: A connected call.
  • No Answer: A call that met the ring time of an extension without being answered.
  • Timeout Exit: Call to a Queue that meets the Timeout.
  • VM Not Left: Call ended with the caller being sent to voicemail where they did not leave a message.
  • VM Left: Call ended with the caller being sent to voicemail where they left a message.
  • Transferred: Connected call successfully transferred.
  • Busy: Call out a trunk returned busy status, or extension was busy.
  • - : Defines the call is still active, and the status will update when completed. Click on the call record for details.
  • Exited Empty Queue: Call to Queue that follows Exit Empty rule.
  • Exited With Key: Call to Queue that follows the Exit Menu key press.
  • Account Code: Reserved for future account name information
  • Authorization Code: Reserved for future authorization code information

Example:

The call is incoming on a hardware channel 1 group 1, the call ID links the two records together. The call first goes to a ring group ‘rg_33’ is answered by SIP/2208 (Elaine), and was transferred after 35 seconds of talking. Because the final flag is not set, we know there will be more about this call in the future.

 

The second entry for the call was picked up by SIP/2210 (Chris) and lasted 81 seconds long. The final entry flag has a ‘1’ signifying it is the last leg of this call.

 

1264086258, 1264086296, Incoming, DAHDI/1-1, 1264086247.6308, 7145554445, 7145554445, Zap/1-1, Elaine Blodgett, , SIP/2208, 9413062200, rg_33, 3, TRANSFERRED,35,

 

1264086296, 1264086395, Incoming, DAHDI/1-1, 1264086247.6308, 7145554445, 7145554445, Zap/1-1, Chris Beavers, 2210, SIP/2210-087b12f0, 9413062200, , , ANSWER, 81, 1