Cisco Unified Communications Manager CDR Analysis and Reporting Administration Guide for Cisco Unified Communications Manager, Release 6.1(1)
CAR Index
Downloads: This chapterpdf (PDF - 702.0KB) The complete bookPDF (PDF - 3.68MB) | Feedback

Index

Table Of Contents

A - B - C - D - E - F - G - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W -

Index

A

AAC calls 10-25

CDR example 10-26

scenarios 10-79

abandoned calls 10-10

abandoned calls examples 10-10

abandoned calls scenario 10-39

activating CAR 2-1

add incoming number prefix to CDR service parameter 2-3

ad hoc conference linking 10-18

call scenarios 10-51

CDR examples 10-51

administrators, CAR 1-6

alerts

enabling or disabling, by mail 4-8

allowed CDRonDemand get_file_list queries per minute service parameter 2-4

allowed CDRonDemand get_file queries per minute enterprise parameter 2-3

application user 2-4

authCodeDescription, CDR field name 10-100

authenticate and show CAR pages 1-15

authorization code name

system report 6-17

authorization code name report 6-17

authorizationCodeValue, CDR field name 10-102

authorization level

system report 6-18

authorizationLevel, CDR field name 10-100

authorization level report 6-18

automatic

database purge 3-14

report generation 4-6

auto pickup 10-13

auto pickup CDR example 10-13

auto pickup scenarios 10-44

B

barge scenarios 10-66

base rate 4-2

bill

department 5-3

department detail, report results 11-4

department summary, report results 11-2

individual 5-1

individual detail, report results 11-4

individual summary, report results 11-2

C

call control process 10-2

call detail

conference call detail, report results 11-42

call Diagnostics Enabled service parameter 2-2

callIdentifier, CMR field name 10-103

call information record types 10-4

callingPartyNumber, CDR field name 10-87

callingPartyNumberPartition, CDR field name 10-97

callingPartyUnicodeLoginUserID, CDR field name 10-87

call monitoring 10-23

call monitoring CDR example 10-23

call park pickup 10-61

call park reversion scenario 10-62

call park scenarios 10-61

call pickup scenarios 10-43

call recording 10-23

call recording CDR example 10-24

call release cause codes 10-8

call scenarios, CDR 10-37

callSecuredStatus, CDR field name 10-101

call secured status scenarios 10-71

calls with busy or bad destinations 10-11

calls with busy or bad destinations CDR examples 10-11

calls with busy or bad destinations scenarios 10-40

call termination

CDR search by 8-5

call termination cause codes, Cisco-specific, table 10-112

call termination cause codes, table 10-110

call types 10-9

QoS by 6-8

QoS report results by call types 11-20

call usage for assistant-detail

report results 11-10

call usage for assistant-summary

report results 11-11

call usage for manager-detail

report results 11-13

call usage for manager-summary

report results 11-14

CAR

administrators, managers, users 1-6

assistant call usage configuration 5-12

automatic database purge configuration 3-14

automatic report generation/alert configuration 4-6

call termination details, viewing 8-6

CDR/CMR records configuration 9-1, 10-1

CDR error report 6-22

CDR error report configuration 6-22

CDR search

by call precedence levels 8-6

configuration 8-1

malicious calls 8-8

overview 1-13

CDR search by cause for call termination configuration 8-5

CDR search by gateway configuration 8-3

CDR search by user extension configuration 8-1

checklist 1-15

Cisco IP Manager Assistant usage reports, described 5-10

Cisco IP Phone services report configuration 5-13

conference bridge utilization report 7-14

conference call details configuration 7-13

configuration, gateway 3-5

department bills configuration 5-3

described 1-3

device report, described 7-1

device reports

overview 1-10

dial plan default values 3-3

disabling automatic database purge 3-14

event log report output parameters 3-16

event log report status 3-15

export CDR/CMR records results 9-2

gateway report 7-1, 7-8

generate report fields 6-7, 6-9, 6-12, 6-14, 6-20

individual bills configuration 5-2

list of topics 1-1

load CDR and CMR values 3-8

logging off 2-6

malicious call identification 6-19

manager call usage configuration 5-11

manual database purge 3-13

notification limits configuration 4-8

overview 2-1

precedence call summary 6-20

QoS by call types configuration 6-8

QoS by call types report 6-8

QoS by gateway configuration 6-6

QoS by gateway report 6-6

QoS default values 4-5

QoS detail report

call types 6-3

voice quality 6-4, 6-13

QoS detail report configuration 6-2

QoS parameter operators 6-2

QoS parameters

call types 6-9

QoS reports, described 6-1

QoS summary report

call types 6-5

QoS summary report configuration 6-4

QoS values, defining 4-5

rating engine configuration 4-1

report configuration, described 4-1

reports, results 11-1

restoring database purge defaults 3-13

restoring dial plan default values 3-3

searching for users 5-14

system configuration 1-6, 3-1

system log screens, described 3-15

system overview report 6-21

system overview report configuration 6-21

system preferences parameters 3-6

system reports

overview 1-9

system reports, described 6-1

top N, described 5-4

top N by charge

call types 5-5

report types 5-6

top N by charge configuration 5-4

top N by duration

call types 5-7

report types 5-8

top N by duration configuration 5-6

top N by number of calls

call types 5-9

report types 5-10

top N by number of calls configuration 5-8

traffic reports

described 6-10

traffic summary (extn), call types 6-15

traffic summary, call types 6-12

traffic summary by extensions report 6-14

traffic summary by extensions report configuration 6-14

traffic summary report 6-11

traffic summary report configuration 6-11

uninhibited loading of CDR values 3-8

user reports 1-7

user reports, described 5-1

voice messaging utilization report 7-16

car_CDRSearchByCauseCodesReport 8-6

CAR logon error message 2-5

cbarge scenarios 10-68

CDR

automatic database purge configuration 3-14

disabling automatic database purge 3-14

disabling loading 3-7

dump table 11-49

error, report results 11-32

error report 6-22

load schedule configuration 3-7

restoring the default load schedule 3-7

search 8-1

search by cause for call termination 8-5

search by gateway 8-3

search by user extension 8-1

search by user extension, report results 11-48

service parameters, configuring 2-2

values

CDR load 3-8

CDR Agent 10-3

CDR analysis and reporting

general information 1-7

internationalization 1-14, 1-15

CDR Analysis and Reporting Tool

described 2-1

logging off 2-6

CDR call scenarios 10-37

CDR Enabled Flag service parameter 2-2

CDR examples 10-9

CDR field descriptions 10-84

CDR file time interval enterprise parameter 2-3

CDR Log Calls With Zero Duration Flag service parameter 2-2

CDR management 10-3

CDR onDemand Service 10-4

CDR overview 10-3

CDR processing 10-1

cdrRecordType, CDR field name 10-84

cdrRecordType, CMR field name 10-102

CDR repository 10-2

CDR Repository Manager 10-4

CDRs

understanding 1-1

CDR values

uninhibited loading 3-8

Cisco IPMA usage reports

manager call usage 5-11

Cisco IP Phone services

report configuration 5-13

report results 11-16

Cisco personal assistant 10-31

Cisco-specific call termination cause codes, table 10-112

Cisco Unified Communications Manager Assistant call usage reports

assistant call usage 5-12

client matter code

system report 6-16

clientMatterCode, CDR field name 10-101

client matter code report 6-16

client matter code reports 6-16

client matter code scenarios 10-71

cluster ID enterprise parameter 2-3

CMC reports 6-16

CMC scenarios 10-71

CMR dump table 11-49

CMR Field Descriptions (Diagnostic), table 10-102

CMR K-Factor data 10-107

CMR values, CDR load 3-8

codec types, table 10-108

comment, CDR field name 10-100

conference bridge utilization, report results 11-44

conference call detail, report results 11-42

conference calls 10-16

conference calls CDR examples 10-17

conference calls scenarios 10-48

conference drop any party 10-22

conference linking 10-18

conference linking, removing a controller from linked conference 10-56

conference linking, removing a party from a linked conference 10-54

conference linking, removing the linked conference 10-58

conference linking, using transfer or direct transfer 10-53

configuration checklist

CAR 1-15

configuring 6-19, 6-20, 8-6, 8-8

conventions iii-xiii

customizing, reports for automatic generation 4-7

customizing reports for automatic generation 1-12

D

daily charges, notification limits configuration 4-8

daily reports

scheduling 3-9

database

automatic purge configuration 3-14

disabling automatic purge 3-14

restoring purge defaults 3-13

dateTimeConnect, CDR field name 10-96

dateTimeDisconnect, CDR field name 10-96

dateTimeOrigination, CDR field name 10-85

dateTimeStamp, CMR field name 10-104

department bill

detail 5-3

summary 5-3

department bill detail

report results 11-4

department bill detail, report results 11-4

department bill summary

report results 11-2

department bill summary, report results 11-2

destCallTerminationOnBehalfOf, CDR field name 10-99

destCause_location 10-92

destCause_value, CDR field name 10-93

destConversationID, CDR field name 10-100

destDeviceName, CDR field name 10-98

destDTMFMethod, CDR field name 10-101

destIpAddr, CDR field name 10-91

destLegCallIdentifier, CDR field name 10-91

destMediaCap_Bandwidth, CDR field name 10-102

destMediaCap_g723BitRate, CDR field name 10-94

destMediaCap_maxFramesPerPacket, CDR field name 10-94

destMediaCap_payloadCapability, CDR field name 10-94

destMediaTransportAddress_IP, CDR field name 10-93

destMediaTransportAddress_Port, CDR field name 10-93

destNodeId, CDR field name 10-91

destPrecedenceLevel, CDR field name 10-93

destRSVPAudioStat, CDR field name 10-95

destRSVPideoStat, CDR field name 10-95

destSpan, CDR field name 10-91

destVideoCap_Bandwidth, CDR field name 10-94

destVideoCap_Codec, CDR field name 10-94

destVideoCap_Resolution, CDR field name 10-94

destVideoTransportAddress_IP, CDR field name 10-94

destVideoTransportAddress_Port, CDR field name 10-95

detail

department bill 5-3

department bill, report results 11-4

gateway 7-1

gateway, report results 11-33

individual bill 5-1

individual bill, report results 11-4

QoS, report results 11-16

QoS report 6-2

details report 6-19

deviceName, CMR field name 10-106

device reports 7-1

device reports, CAR 1-10

dial plan, configuration 3-2

directoryNumber, CMR field name 10-104

directoryNumberPartition, CMR field name 10-106

disabling

alerts by mail 4-8

automatic CAR and CDR database purge 3-14

automatic database purge 3-14

CDR loading 3-7

display FAC in CDR service parameter 2-3

document

audience iii-xii

conventions iii-xiii

organization iii-xii

purpose iii-xi

documentation

related iii-xiii

DTMF methods 10-72

dump table, CDR and CMR 11-49

duration 4-2

duration, CDR field name 10-98

E

enabling

alerts by mail 4-8

reports for automatic generation 4-7

enabling reports for automatic generation 1-12

enterprise parameter

allowed CDRonDemand get_file queries per minute 2-3

CDRfile time interval 2-3

cluster ID 2-3

enterprise parameters 2-3

error

CDR report 6-22

CDR report, results 11-32

event log

generating 3-15

event log, generating 1-6

event log report

output 3-16

status 3-15

extension

CDR search by 8-1

CDR search by, report results 11-48

F

FAC scenarios 10-70

filename format 10-2

finalCalledPartyNumber, CDR field name 10-92

finalCalledPartyNumberPartition, CDR field name 10-97

finalCalledPartyUnicodeLoginUserID, CDR field name 10-92

flat file format 10-2

forced authorization code scenarios 10-70

forwarded calls 10-11

forwarded calls scenarios 10-41

forward or redirected call CDR examples 10-12

G

gateway

CDR search by 8-3

configuration for CAR 3-5

QoS by 6-6

QoS report results by gateway 11-19

gateway detail

call types 7-2, 7-5

voice quality 7-3

gateway detail, report results 11-33

gateway detail report 7-1

gateway report, configuring 7-1

gateway summary, report results 11-35

gateway summary report 7-4

gateway utilization, report results 11-38

gateway utilization report 7-6

generate report fields 7-7, 7-9, 7-10, 7-12, 7-15, 7-16

generating

event log 3-15

globalCallID_callId, CDR field name 10-85

globalCallId_callId, CMR field name 10-103

globalCallID_callManagerID, CDR field name 10-84

globalCallID_callManagerId, CMR field name 10-103

globalCallId_ClusterId, CDR field name 10-100

globalCallId_ClusterId, CMR field name 10-106

global call identifier 10-5

I

identity management system error message 2-5

idivert scenarios 10-65

iLBC calls 10-25

CDR example 10-27

scenarios 10-79

immediate divert (to voicemail) 10-22

immediate divert (to voicemail) scenarios 10-65

immediate divert CDR example 10-22

IMS error message 2-5

individual bill

configuration 5-2

detail 5-1

summary 5-1

individual bill detail

report results 11-4

individual bill detail, report results 11-4

individual bill summary

report results, report results

department bill summary 11-2

individual bill summary, report results 11-2

intercom 10-29

intercom calls scenario 10-83

intercom CDR example 10-29

internationalization for CDR analysis and reporting 1-14

interpreting personal assistant data in CDRs 10-31

IP addresses 10-8

J

jitter, CMR field name 10-105

joinOnBehalfOf, CDR field name 10-100

K

K-Factor data in CMRs 10-107

L

lastRedirectDn, CDR field name 10-96

lastRedirectDnPartition, CDR field name 10-98

lastRedirectRedirectOnBehalfOf, CDR field name 10-99

lastRedirectRedirectReason, CDR field name 10-99

latency, CMR field name 10-106

legacy call pickup scenarios 10-44

load

CDR schedule configuration 3-7

disabling CDR 3-7

restoring the default CDR schedule 3-7

logging off CAR 2-6

logon error message 2-5

logon page 1-14

M

mailing a report 5-13

mail server parameters 3-1

malicious calls 10-21

malicious calls CDR example 10-22

malicious calls scenarios 10-64

managers, CAR 1-6

manual database purge, configuration 3-13

media information 11-49

meet-me conference CDR examples 10-18

meet-me conferences 10-18

meet-me secure conference scenarios 10-50

mobility 10-27

mobility call pickup example 10-82

mobility follow me example 10-80

mobility handin example 10-80

mobility handout example 10-81

mobility IVR example 10-82

mobility scenarios 10-80

monitor calls scenarios 10-76

monthly reports

scheduling 3-11

N

nodeId, CMR field name 10-103

normal calls scenario 10-38

notification limits 4-8

numberOctetsReceived, CMR field name 10-105

numberOctetsSent, CMR field name 10-104

numberPacketsLost, CMR field name 10-105

numberPacketsReceived, CMR field name 10-104

numberPacketsSent, CMR field name 10-104

number translations 10-5

O

OnBehalfOf codes, table 10-114

on-net calls 10-10

organization iii-xii

origCalledPartyRedirectOnBehalfOf, CDR field name 10-99

origCalledPartyRedirectReason, CDR field name 10-99

origCallTerminationOnBehalfOf, CDR field name 10-98

origCause_location, CDR field name 10-87

origCause_value, CDR field name 10-88

origConversationID, CDR field name 10-102

origDeviceName, CDR field name 10-98

origDTMFMethod, CDR field name 10-101

originalCalledPartyNumber, CDR field name 10-92

originalCalledPartyNumberPartition, CDR field name 10-97

original calling party on transfer 10-30

original calling party on transfer CDR example 10-30

origIpAddr, CDR field name 10-86

origLegCallIdentifier, CDR field name 10-85

origMediaCap_Bandwidth, CDR field name 10-102

origMediaCap_g72.3BitRate, CDR field name 10-89

origMediaCap_maxFramesPerPacket, CDR field name 10-89

origMediaCap_payloadCapability, CDR field name 10-89

origMediaTransportAddress_IP, CDR field name 10-88

origMediaTransportAddress_Port, CDR field name 10-89

origNodeId, CDR field name 10-85

origPrecedenceLevel, CDR field name 10-88

origRSVPAudioStat, CDR field name 10-90

origRSVPVideoStat, CDR field name 10-90

origSpan, CDR field name 10-86

origVideoCap_Bandwidth, CDR field name 10-89

origVideoCap_Codec, CDR field name 10-89

origVideoCap_Resolution, CDR field name 10-89

origVideoTransportAddress_IP, CDR field name 10-90

origVideoTransportAddress_Port, CDR field name 10-90

overview

automatic report generation 4-6

CAR 2-1

department bill reports 5-3

device reports 7-1

error and event logs 1-6

individual bill reports 5-1

system report 6-21

P

parameters

factoring time of day for rating 4-3

factoring voice quality for rating 4-4

mail server configuration 3-1

setting the base rate and duration for rating 4-2

system configuration 3-1

partitions and numbers 10-6

personal assistant conferencing 10-36

personal assistant conferencing CDR example 10-36

personal assistant data 10-31

personal assistant data in CDRs 10-31

personal assistant direct call 10-31

personal assistant direct call CDR example 10-31

personal assistant interceptor going to media port and transferring the call 10-32

personal assistant interceptor going to media port and transferring the call CDR example 10-32

personal assistant interceptor going to multiple destinations 10-33

personal assistant interceptor going to multiple destinations CDR examples 10-33

personal media interceptor going directly to destination CDR examples 10-32

pickup call CDR example 10-12

pickup calls 10-12

pkid, CDR field name 10-96

pkid, CMR field name 10-106

precedence calls (MLPP) 10-21

precedence calls CDR example 10-21

precedence calls scenarios 10-63

preferences

system configuration 3-6

purge

automatic database configuration 3-14

disabling automatic database 3-14

restoring database defaults 3-13

Q

QoS

default values 4-5

defining values 4-5

notification limits configuration 4-8

QoS by call types, report results 11-20

QoS by call types report 6-8

QoS by gateway, report results 11-19

QoS by gateway report 6-6

QoS detail, report results 11-16

QoS detail report

call types 6-3

voice quality 6-4, 6-13

QoS parameters, call types 6-9

QoS summary, report results 11-18

QoS summary report

call types 6-5

R

rating engine, configuration 4-1

rating parameters

factoring time of day 4-3

factoring voice quality 4-4

setting the base rate and duration 4-2

recording calls scenarios 10-78

redirected calls 10-11

Redirection (3xx) call scenarios 10-74

redirect reason codes, table 10-113

refer calls 10-76

related documentation iii-xiii

replaces calls scenarios 10-75

report

authorization code name 6-17

authorization level 6-18

CDR error 6-22

CDR search 8-1

CDR search by cause for call termination 8-5

CDR search by gateway 8-3

CDR search by user extension 8-1

Cisco IPMA 5-11

Cisco Unified Communications Manager Assistant 5-12

client matter code 6-16

department bill 5-3

device 7-1

gateway detail report 7-1

gateway summary 7-4

gateway utilization 7-6

individual bill 5-1

mailing 5-13

QoS by call types report 6-8

QoS by gateway report 6-6

QoS detail 6-2

route and line group utilization 7-8

route list utilization 7-10

route pattern/hunt pilot utilization 7-11

system 6-1

system overview 6-21

top N by charge 5-4

top N by duration 5-6

top N by number of calls 5-8

traffic summary 6-11

traffic summary by extensions 6-14

voice-mail utilization 7-16

report configuration, CAR 4-1

report results

call usage for assistant-detail 11-10

call usage for assistant-summary 11-11

call usage for manager-detail 11-13

call usage for manager-summary 11-14

CDR error 11-32

CDR search by user extension 11-48

Cisco IP Phone services 11-16

conference bridge utilization 11-44

conference call detail 11-42

department bill, detail 11-4

department bill, summary 11-2

department bill detail 11-4

gateway detail 11-33

gateway summary 11-35

gateway utilization 11-38

individual bill, detail 11-4

individual bill, summary 11-2

individual bill detail 11-4

individual bill summary 11-2

QoS by gateway 11-19

QoS detail 11-16

QoS report by call types 11-20

QoS summary 11-18

route group utilization 11-38

route list utilization 11-38

route pattern utilization 11-38

system overview 11-31

top N by charge 11-6

top N by duration 11-6

top N by number of calls 11-8

traffic summary 11-22

traffic summary by extensions 11-22

voice mail utilization 11-46

Reports

CAR report results 11-1

reports

automatic generation configuration 4-6

automatic report generation/alert 4-6

customizing for automatic generation 1-12, 4-7

enabling for automatic generation 1-12, 4-7

overview 1-15

scheduling daily 3-9

scheduling monthly 3-11

scheduling weekly 3-10

system overview results 11-31

user 5-1

user, CAR 1-7

restoring

CAR database purge defaults 3-13

default CDR load schedule 3-7

role-based call routing 10-31

route

group utilization, report results 11-38

list utilization, report results 11-38

pattern utilization, report results 11-38

route and line group utilization report 7-8

route list utilization report 7-10

route pattern/hunt pilot utilization report 7-11

route plan utilization report, configuring 7-8

RSVP call scenarios 10-73

S

schedule

CDR load configuration 3-7

restoring the default CDR load 3-7

scheduling

daily reports 3-9

monthly reports 3-11

weekly reports 3-10

search

CDR by cause for call termination 8-5

CDR by gateway 8-3

CDR by user extension 8-1

CDR by user extension, report results 11-48

CDRs 8-1

searching for users, CAR 5-14

secure meet-me conference scenarios 10-50

server, mail parameters 3-1

service parameter

add incoming number prefix to CDR 2-3

allowed CDRonDemand get_file_list queries per minute 2-4

call diagnostics enabled 2-2

CDR Enabled Flag 2-2

CDR Log Calls With Zero Duration Flag 2-2

display FAC in CDR 2-3

show line group member DN in finalCalledPartyNumber CDR field 2-3

short call CDR example 10-11

short calls 10-11

show line group member DN in finalCalledPartyNumber CDR fields service parameter 2-3

speech-enabled directory dialing 10-31

speech-enabled simple ad hoc conferencing 10-31

speech-enabled voice-mail browsing 10-31

successful on-net call CDR examples 10-10

successful on-net calls 10-10

summary

department bill 5-3

gateway 7-4

gateway, report results 11-35

individual bill 5-1

QoS, report results 11-18

traffic 6-11

traffic, report results 11-22

traffic by extensions 6-14

traffic by extensions, report results 11-22

system, CAR 1-6

system overview, report results 11-31

system overview report 6-21

system parameters, configuration 3-1

system preferences

configuration 3-6

system preferences parameters for CAR 3-6

system reports, CAR 1-9

T

table, CDR and CMR dump 11-49

talk-back intercom example 10-83

time of day 4-3

timestamps 10-7

top N

by charge 5-4

by charge, report results 11-6

by duration 5-6

by duration, report results 11-6

by number of calls 5-8

by number of calls, report results 11-8

top N by charge

call types 5-5

report types 5-6

top N by charge, report results 11-6

top N by duration

call types 5-7

configuration 5-6

report types 5-8

top N by duration, report results 11-6

top N by number of calls

call types 5-9

configuration 5-8

report types 5-10

top N by number of calls, report results 11-8

traffic summary 6-11

traffic summary (extn), call types 6-15

traffic summary, call types 6-12

traffic summary, report results 11-22

traffic summary by extensions, report results 11-22

traffic summary by extensions report 6-14

transferred calls 10-13

transferred calls CDR examples 10-14

transferred calls scenarios 10-45

transfer with consultation 10-15

transfer with consultation CDR examples 10-15

transfer without consultation 10-15

transfer without consultation CDR examples 10-15

types of codec, table 10-108

U

uninhibited loading of CDR values 3-8

unsuccessful calls scenarios 10-40

user reports, CAR 1-7

user reports, described 5-1

users, CAR 1-6

using 3-13

utilization

conference bridge, report results 11-44

gateway 7-6

gateway, report results 11-38

route and line group 7-8

route group, report results 11-38

route list 7-10

route list, report results 11-38

route pattern/hunt pilot 7-11

voice-mail 7-16

voice mail, report results 11-46

V

varVQMetrics, CMR field name 10-107

video calls 10-23

video calls CDR example 10-23

video calls scenarios 10-69

viewing 9-2

voice mail utilization, report results 11-46

voice-mail utilization report 7-16

voice quality 4-4

W

weekly reports

scheduling 3-10

whisper intercom example 10-83