Wiki source code of CDR Reports
Last modified by Cameron Marx on 2023/08/27 21:37
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | (% class="jumbotron" %) | ||
| 2 | ((( | ||
| 3 | (% class="container" %) | ||
| 4 | ((( | ||
| 5 | = CDR Reports = | ||
| 6 | |||
| 7 | Call Reports is designed to be the raw data of all call activity on your phone system. It can be a very challenging module to work with because it’s not in a very user-friendly format and there is so | ||
| 8 | much raw Call Detail Records (CDR). It is really meant as a way to export the data so you can build your own custom reports around the raw data. | ||
| 9 | ))) | ||
| 10 | ))) | ||
| 11 | |||
| 12 | (% class="row" %) | ||
| 13 | ((( | ||
| 14 | (% class="col-xs-12 col-sm-8" %) | ||
| 15 | ((( | ||
| 16 | = Search Parameters = | ||
| 17 | |||
| 18 | From the landing page you can run reports against your CDR database and filter on the following: | ||
| 19 | |||
| 20 | * **Call Date**: Select time span for your report. You can select Date, Month, Year, Hour and Minute to narrow your search | ||
| 21 | * **CallerID Number**: Search for calls based on CallerID Number. You can enter multiple numbers separated by a comma. This field support Asterisk regular expression | ||
| 22 | * **CallerID Name**: Select CallerID Name to search for | ||
| 23 | * **Outbound CallerID Number**: Search for calls based on outbound CID used. You can enter multiple numbers separated by a comma. This field support Asterisk regular expression | ||
| 24 | * **DID**: Search for a DID | ||
| 25 | * **Destination**: Search for destination calls. You can enter multiple sources separated by a comma. This field support Asterisk regular expression | ||
| 26 | * **Destination CallerID Name**: Select Destination Caller Name to search for | ||
| 27 | * **Userfield**: Search for userfield data (if enabled) | ||
| 28 | * **Account Code**: Search for accountcode | ||
| 29 | * **Duration**: Search for calls that matches the call length specified | ||
| 30 | * **Disposition**: Search for calls that matches either ANSWERED, BUSY, FAILED or NO ANSWER | ||
| 31 | |||
| 32 | == Sample Usage == | ||
| 33 | |||
| 34 | {{info}} | ||
| 35 | Note: the default search behavior is "Begins With". Switch to "Contains" if searches are not returning expected results. | ||
| 36 | {{/info}} | ||
| 37 | |||
| 38 | === Search for all calls from a specified caller ID number === | ||
| 39 | |||
| 40 | Example: Show all calls coming from a specified caller ID number. Note that this will identify both external callers calling in and internal callers calling out if the incoming or outgoing caller ID number (respectively) matches. | ||
| 41 | |||
| 42 | * **Call Date:** set a date and time range if desired | ||
| 43 | * **CallerID Number:** set this to the desired caller ID number, e.g. 5551234567, and select "Contains" on the right of this field | ||
| 44 | * click "Search" | ||
| 45 | |||
| 46 | === Search for all calls from a specified caller ID name string === | ||
| 47 | |||
| 48 | Example: Show all calls coming from a specified caller ID name string "SMITH". Note that this will identify both external callers calling in and internal callers calling out if the incoming or outgoing caller ID name string (respectively) matches. | ||
| 49 | |||
| 50 | * **Call Date:** set a date and time range if desired | ||
| 51 | * **CallerID Name:** set this to the desired caller ID string, e.g. "smith" (case doesn't matter but don't enter the quotes), and select "Contains" on the right of this field | ||
| 52 | * click "Search" | ||
| 53 | |||
| 54 | === Search for all calls coming in to a specified external DID number === | ||
| 55 | |||
| 56 | Example: Our organization has several external numbers (direct inbound dial numbers or DIDs). Show all calls dialing to one of these DID number, specifically 555-123-4567. | ||
| 57 | |||
| 58 | * **Call Date:** set a date and time range if desired | ||
| 59 | * **DID:** set this to the desired external DID number 5551234567 (don't enter hyphens, spaces or any other punctuation) | ||
| 60 | * click "Search" | ||
| 61 | |||
| 62 | === Search for all calls coming in to a specified internal extension === | ||
| 63 | |||
| 64 | Example: Show all calls dialing to an internal extension, number 700. | ||
| 65 | |||
| 66 | * **Call Date:** set a date and time range if desired | ||
| 67 | * **Destination:** set this to the desired internal extension number, 700 | ||
| 68 | * click "Search" | ||
| 69 | |||
| 70 | === Asterisk Regular Expression/Pattern Matching === | ||
| 71 | |||
| 72 | * X = matches any digit from 0-9 | ||
| 73 | * Z = matches any digit from 1-9 | ||
| 74 | * N = matches any digit from 2-9 | ||
| 75 | * [1237-9] = matches any digit or letter in the brackets (in this example, 1,2,3,7,8,9) | ||
| 76 | * . = wildcard, matches one or more characters | ||
| 77 | |||
| 78 | Examples: | ||
| 79 | |||
| 80 | **_2XXN, _562., _.0075** = search for any match of these numbers | ||
| 81 | **_!2XXN, _562., _.0075** = Search for any match except for these numbers | ||
| 82 | ))) | ||
| 83 | |||
| 84 | |||
| 85 | (% class="col-xs-12 col-sm-4" %) | ||
| 86 | ((( | ||
| 87 | {{box title="**Contents**"}} | ||
| 88 | {{toc depth="2"/}} | ||
| 89 | {{/box}} | ||
| 90 | |||
| 91 | [[image:ReportsCDRreports.png||alt="CallDetailReports.jpg"]] | ||
| 92 | //Figure 1: Call Detail Reports with Search Results// | ||
| 93 | ))) | ||
| 94 | ))) |