# CDR Reports

You can generate on-screen reports of your CDR message data. There are a number of ways to customize these reports, including which messages to include, which fields to include, and how to format your report. Report creation and modification options are available in the CDR Report menu.

Although you cannot use the Web Console to enable or configure CDR, you can use it to produce custom CDR reports.

## Report Options

These are the options available in the CDR Report menu. You must exit the Report Menu to save any changes you make here.

## Report Details

There are 26 fields, or report details, that can be stored in a CDR record. You can include a subset of the available information in your report, which is the set of information you will later download. If you only need some of the data, you can specify which fields you want to include in the report.

The CDR Record Fields table lists all fields and their descriptions. The following table lists their field lengths and formats, so you can compute your report width and set up your remote application properly.

## Call Types

You can select any or all 28 Call Types in your report. In particular, Call Type 1 creates a large number of messages, and you might not want to include it. See CDR Records for a list of Call Types.

Do not confuse specifying which Call Types are stored by the server with which Call Types are included in your report. The former is chosen in the Configuration Menu, the latter in the Report Menu.

CDR Record Field Lengths and Formats
Field | Code | Length | Format
--- | --- | --- | ---
1 | CSN | 6 | nnnnnn
2 | DATE | 6 | mmddyy (month, day, year)
3 | TIME | 6 | hhmmss (hour, minute, second)
4 | STIM | 6 | hhmmss (hour, minute, second)
5 | PORT | 6 | mmppll (module, port, line)
6 | SYID | 4 | xxxx (first 4 chars of site code)
7 | CDUR | 4 | ssss (seconds)
8 | FMBX | 14* | nnnnnnnnnnnnnn
9 | TMBX | 14* | nnnnnnnnnnnnnn
10 | FNUM | 16* | nnnnnnnnnnnnnnnn
11 | TNUM | 16* | nnnnnnnnnnnnnnnn
12 | MSG | 7 | nnnnnnn
13 | CT | 2 | nn
14 | AT | 2 | nn
15 | TT | 2 | nn
16 | ME | 2 | nn
17 | PE | 2 | nn
18 | MS | 2 | nn
19 | MP | 2 | nn
20 | MD | 2 | nn
21 | MK | 2 | nn
22 | TA | 2 | nn
23 | EC | 2 | nn
24 | FS | 2 | nn
25 | FP | 2 | nn
26 | PS | 2 | nn
n = numeric character, x = alphanumeric character, other characters are defined. * = maximum length possible for this variable field. The default length is 11.

## Field Lengths

You can adjust the field lengths of four CDR fields: 8, 9, 10 and 11 (FMBX, TMBX, FNUM and TNUM). These fields contain mailbox or telephone numbers. For example, if all your mailboxes are four characters, you can set fields 8 and 9 (the From and To Mailbox fields) to a length of 4 instead of 11 (the default). This saves space in your output. You can also increase the length of these fields, if necessary.

If your field data is shorter than the field length, the data is right-justified and filled with the string pad character you specify. This pad character is described below.

## Field Delimiter

You can specify a field delimiter to make data processing easier on the remote computer system. For example, some processing applications require comma separated fields. The default delimiter is a space between details.

Enter 0 for a space, 1 for a tab, or any other character for another delimiter. Be sure you know what field delimiter is required by the remote application using the data.

## Report Width

Once you know how many details to include, and you have determined field lengths for the adjustable details, you can set a width for the report by using the Number of Columns option. This allows you to better view the on-screen report or to allow one entire record on one line for a remote download.

The default is 40 columns, and you can specify a number between 40 and 160. If your CDR records need more columns than your screen can display, it wraps extra characters to a second or third line. Select a width based on whether you want to display the report on your server console or download the data. Use the larger widths for downloading. Most VT-100 terminal displays are 80 columns wide--72 or 80 is a good choice for these terminals.

When setting this parameter, be aware of how many details you specified for your report, and the field lengths you set. This ensures that your report is readable without unexpected wraparound.

## Call Sequence Number Range

You can adjust your report to include all CDR records, or a range of records, by choosing a starting and ending Call Sequence Number. By determining when certain calls were placed, this feature allows you to report messages for a specific time period.

CDR assigns consecutive sequence numbers to each call until number 999999; the next call is assigned number 1. If CDR exceeds its maximum number of records, it overwrites the oldest record. However, the newest record does not reuse the oldest record’s sequence number. Either of these occurrences can cause the ending number to be lower than the starting number for a particular time period. A lower ending sequence number is no problem for CDR, but you should be aware of the possibility.

## Search Capability

You can specify a search string for your report using the Search For option. This is useful if you want to see data for a particular mailbox or telephone number. Your search string can be up to 160 characters. Enter a period (.) to reset the search to blank.

Since you cannot specify the position of your search string, searches for a particular call type, such as "01," are meaningless. Your results list all occurrences of "01" anywhere in all CDR records. The feature is best used for finding longer strings, such as telephone or mailbox numbers.

To ensure you are finding a particular string, use the delimiter character as a boundary. This prevents finding your string within a larger field. For example, if you are searching for mailbox 5760, and enter the search string 5760, you also find records with the DN 4085555760 and 2125760555. To prevent this, use the search string " 5760 " (this example assumes a space is your delimiter and that your mailbox field lengths are set to four characters).

## String Pad Character

You can specify which character to use to pad data fields. The default is 0 (zero). Padding is used when the result takes up fewer characters than the space allotted for the field. For example, if your mailbox fields are 11 characters, and a record contains four-digit mailbox information, a pad character of zero results in 00000001234. If you change the pad character to a space, your result is 1234.

Note: You cannot enter a period (.) as your string pad character.

## Sample Output

The figure below shows a sample of CDR report output. The delimiter is a blank, and all report details (fields) are shown. The report width is set to 80, so each CDR record is on two lines (this avoids splitting any of the data fields). The field lengths are set to 11 (the default), and are zero-filled (that is, padded with leading zeroes).

This report was created by the Generate On-Screen Report option.

275282 071892 025245 025250 0412 0000 0005 00000000000 00000003563 00000000000 55223183563 0000000 05 08 01 00 00 00 00 00 00 00 01 00 00 00

275284 071892 025236 025422 0401 0000 0106 00000000000 00000003565 00000000000 00000000000 0622073 17 02 02 00 00 01 00 00 00 00 01 00 00 00

275290 071892 034454 034517 0213 0000 0023 00000000000 00000003728 00000000000 00000000000 0000000 16 02 01 00 00 00 00 00 00 00 01 00 00 00

275294 071892 044933 045039 0413 0000 0066 00000000000 00000003561 00000000000 19134510876 0623891 04 08 01 00 00 00 00 00 00 00 01 01 00 02

275371 071892 081446 081903 0000 0000 0257 00000005223 00000076582 00000000001 00000000140 0622103 07 08 01 00 00 00 00 00 00 00 01 00 00 00

275459 071892 101125 101135 0307 0000 0010 00000000000 00000003001 00000000000 00000000000 0000000 12 01 01 00 00 00 00 00 00 00 01 00 00 00

275908 071992 100211 100237 0314 0000 0026 00000000000 00000000000 17035504009 00000000000 0000000 21 08 01 00 00 00 00 00 00 00 01 00 00 00

275912 071992 100237 100345 0314 0000 0068 00000004000 00000003512 17035504009 00000000000 1015499 09 08 01 00 00 01 00 00 00 00 01 00 00 00

## Sample CDR Report Output

There are also report options that create immediate results. Display CDR Statistics produces the following output:

REPORT STATISTICS:

Call Sequence Number of oldest message: 1633

Call Sequence Number of next message: 1642

Display Download Statistics produces the following output:

DOWNLOAD STATISTICS:

Most recent Call Sequence Number: 230

Most recent Record: 2

Download Start Time: 1-Sep-92 5:05:21 pm

Download Stop Time: 1-Sep-92 5:05:57 pm

Download Result: OK

The download statistics are only updated when you download new CDR records. If you select a range of Sequence Numbers to download, the statistics are not affected.

Parent topic: Reporting