-
Cisco Unified CallManager CDR Analysis and Reporting Administration Guide, Release 5.1(3)
-
Index
-
Preface
-
CDR Analysis and Reporting Overview
-
Getting Started with CDR Analysis and Reporting
-
CAR System Configuration
-
CAR Report Configuration
-
CAR User Reports Configuration
-
CAR System Reports Configuration
-
CAR Device Reports Configuration
-
CDR Search Configuration
-
Export CDR/CMR Records Configuration
-
CAR Report Results
-
Table Of Contents
A - B - C - D - E - G - I - L - M - N - O - P - Q - R - S - T - U - V - W -
Index
A
add incoming number prefix to CDR service parameter 2-3
administrators, CAR 1-5
alerts
enabling or disabling, by mail 4-8
allowed CDRonDemand get_file_list queries per minute service parameter 2-3
allowed CDRonDemand get_file queries per minute enterprise parameter 2-3
authenticate and show CAR pages 1-14
authorization code name
call details report results 10-14
system report 6-17
authorization code name report 6-17
authorization level
call details report results 10-15
system report 6-18
authorization level report 6-18
automatic
database purge 3-14
report generation 4-6
B
base rate 4-2
bill
department 5-3
department detail, report results 10-3
department summary, report results 10-2
individual 5-1
individual detail, report results 10-3
individual summary, report results 10-2
C
call detail
conference call detail, report results 10-21
call Diagnostics Enabled service parameter 2-2
call termination
CDR search by 8-4
call types
QoS by 6-8
QoS report results by call types 10-12
call usage for assistant
detail report results 10-6
summary report results 10-7
call usage for manager
detail report results 10-8
summary report results 10-8
CAR
administrators, managers, users 1-5
assistant call usage configuration 5-12
automatic database purge configuration 3-14
automatic report generation/alert configuration 4-6
call termination details, viewing 8-5
CDR/CMR records configuration 9-1
CDR error report 6-22
CDR error report configuration 6-22
CDR search
by call precedence levels 8-5
configuration 8-1
malicious calls 8-6
overview 1-12
CDR search by cause for call termination configuration 8-4
CDR search by gateway configuration 8-3
CDR search by user extension configuration 8-1
checklist 1-15
Cisco IP Phone services report configuration 5-13
Cisco Unified CallManager Assistant usage reports, described 5-10
conference bridge utilization report 7-14
conference call details configuration 7-13
configuration, gateway 3-5
department bills configuration 5-3
described 1-2
device report, described 7-1
device reports
overview 1-10
dial plan default values 3-4
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
generate report fields 6-7, 6-9, 6-11, 6-14, 6-20
individual bills configuration 5-2
list of topics 1-1
load CDR and CMR values 3-8
logging off 2-5
Malicious Call Identification 6-19
manager call usage configuration 5-11
manual database purge 3-12
notification limits configuration 4-9
overview 2-1
precedence call summary 6-19
QoS by call types configuration 6-8
QoS by call types report 6-8
QoS default values 4-5
QoS detail report
call types 6-3
QoS detail report configuration 6-2
QoS parameter operators 6-2
QoS parameters
call types 6-9
described 6-6
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 10-1
restoring database purge defaults 3-12
restoring dial plan default values 3-4
searching for users 5-15
system overview report 6-21
system overview report configuration 6-21
system preferences parameters 3-6
system reports
overview 1-8
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-14
traffic summary, call types 6-12
traffic summary by extensions report 6-13
traffic summary by extensions report configuration 6-13
traffic summary report 6-11
traffic summary report configuration 6-11
uninhibited loading of CDR values 3-9
user reports 1-7
user reports, described 5-1
voice messaging utilization report 7-16
car_CDRSearchByCauseCodesReport 8-5
CDR
automatic database purge configuration 3-14
disabling automatic CAR database purge 3-14
disabling loading 3-7
dump table 10-26
error, report results 10-18
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-4
search by gateway 8-3
search by user extension 8-1
search by user extension, report results 10-23
service parameters, configuring 2-2
values
CDR load 3-8
CDR analysis and reporting
general information 1-6
internationalization 1-13, 1-14
CDR Analysis and Reporting Tool
described 2-1
logging off 2-5
CDR Enabled Flag service parameter 2-2
CDR file time interval enterprise parameter 2-3
CDR Log Calls With Zero Duration Flag service parameter 2-2
CDRs
understanding 1-1
CDR values
uninhibited loading 3-9
Cisco IPMA usage reports
assistant call usage 5-12
manager call usage 5-11
Cisco IP Phone services
report configuration 5-13
report results 10-9
client matter code
detail report results 10-15
system report 6-16
client matter code report 6-16
cluster ID enterprise parameter 2-3
CMR dump table 10-26
CMR values, CDR load 3-8
conference bridge utilization, report results 10-22
conference call detail, report results 10-21
configuration checklist
CAR 1-15
conventions xi
customizing, reports for automatic generation 4-7
customizing reports for automatic generation 1-11
D
daily charges, notification limits configuration 4-9
daily reports
scheduling 3-9
database
automatic purge configuration 3-14
disabling automatic purge 3-14
restoring purge defaults 3-12
department bill
detail 5-3
summary 5-3
department bill detail, report results 10-3
department bill summary, report results 10-2
detail
department bill 5-3
department bill, report results 10-3
gateway 7-1
gateway, report results 10-18
individual bill 5-1
individual bill, report results 10-3
QoS, report results 10-10
QoS report 6-2
details report 6-19
device reports 7-1
device reports, CAR 1-10
dial plan, configuration 3-2
disabling
alerts by mail 4-8
automatic CAR database and CDR purge 3-14
automatic database purge 3-14
CDR loading 3-7
display FAC in CDR service parameter 2-2
document
audience x
conventions xi
organization x
purpose ix
documentation
related xi
dump table, CDR and CMR 10-26
duration 4-2
E
enabling
alerts by mail 4-8
reports for automatic generation 4-7
enabling reports for automatic generation 1-11
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 10-18
event log
generating 3-15
event log, generating 1-5
event log report
output 3-16
status 3-15
extension
CDR search by 8-1
CDR search by, report results 10-23
G
gateway
CDR search by 8-3
configuration for CAR 3-5
QoS report results by gateway 10-12
gateway detail
voice quality 7-3
gateway detail, report results 10-18
gateway detail report 7-1
gateway report, configuring 7-1
gateway summary, report results 10-19
gateway summary report 7-4
gateway utilization, report results 10-21
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
I
individual bill
configuration 5-2
detail 5-1
summary 5-1
individual bill detail, report results 10-3
individual bill summary, report results 10-2
internationalization for CDR analysis and reporting 1-13
L
load
CDR schedule configuration 3-7
disabling CDR 3-7
restoring the default CDR schedule 3-7
logging off CAR 2-5
logon page 1-14
M
mailing a report 5-14
mail server parameters 3-2
malicious call details
report results 10-16
managers, CAR 1-5
manual database purge, configuration 3-12
media information 10-25
monthly reports
scheduling 3-11
N
notification limits 4-9
O
organization x
overview
automatic report generation 4-6
CAR 2-1
department bill reports 5-3
device reports 7-1
error and event logs 1-5
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-2
setting the base rate and duration for rating 4-2
system configuration 3-1
precedence call summary
report results 10-16
preferences
system configuration 3-6
purge
automatic database configuration 3-14
disabling automatic database 3-14
restoring database defaults 3-12
Q
QoS
default values 4-5
defining values 4-5
notification limits configuration 4-9
QoS by call types, report results 10-12
QoS by call types report 6-8
QoS by gateway, report results 10-12
QoS detail, report results 10-10
QoS detail report
call types 6-3
QoS parameter operators 6-2
QoS parameters, call types 6-9
QoS summary, report results 10-11
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
related documentation xi
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-4
CDR search by gateway 8-3
CDR search by user extension 8-1
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-14
QoS by call types report 6-8
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-13
voice-mail utilization 7-16
report configuration, CAR 4-1
report results
CDR error 10-18
CDR search by user extension 10-23
Cisco IP Phone services 10-9
conference bridge utilization 10-22
conference call detail 10-21
department bill, detail 10-3
department bill, summary 10-2
gateway detail 10-18
gateway summary 10-19
gateway utilization 10-21
individual bill, detail 10-3
individual bill, summary 10-2
QoS by gateway 10-12
QoS detail 10-10
QoS report by call types 10-12
QoS summary 10-11
route group utilization 10-21
route list utilization 10-21
route pattern utilization 10-21
system overview 10-17
top N by charge 10-4
top N by duration 10-4
top N by number of calls 10-5
traffic summary 10-13
traffic summary by extensions 10-13
voice mail utilization 10-23
Reports
CAR report results 10-1
reports
automatic generation configuration 4-6
automatic report generation/alert 4-6
customizing for automatic generation 1-11, 4-7
enabling for automatic generation 1-11, 4-7
overview 1-14
scheduling daily 3-9
scheduling monthly 3-11
scheduling weekly 3-10
system overview results 10-17
user 5-1
user, CAR 1-7
restoring
CAR database purge defaults 3-12
default CDR load schedule 3-7
route
group utilization, report results 10-21
list utilization, report results 10-21
pattern utilization, report results 10-21
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
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-4
CDR by gateway 8-3
CDR by user extension 8-1
CDR by user extension, report results 10-23
CDRs 8-1
searching for users, CAR 5-15
server, mail parameters 3-2
service parameter
add incoming number prefix to CDR 2-3
allowed CDRonDemand get_file_list queries per minute 2-3
call diagnostics enabled 2-2
CDR Enabled Flag 2-2
CDR Log Calls With Zero Duration Flag 2-2
display FAC in CDR 2-2
show line group member DN in finalCalledPartyNumber CDR field 2-3
show line group member DN in finalCalledPartyNumber CDR fields service parameter 2-3
summary
department bill 5-3
department bill, report results 10-2
gateway 7-4
gateway, report results 10-19
individual bill 5-1
individual bill, report results 10-2
QoS, report results 10-11
traffic 6-11
traffic, report results 10-13
traffic by extensions 6-13
traffic by extensions, report results 10-13
system, CAR 1-5
system overview, report results 10-17
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-8
T
table, CDR and CMR dump 10-26
time of day 4-3
top N
by charge 5-4
by charge, report results 10-4
by duration 5-6
by duration, report results 10-4
by number of calls 5-8
by number of calls, report results 10-5
top N by charge
call types 5-5
report types 5-6
top N by charge, report results 10-4
top N by duration
call types 5-7
configuration 5-6
report types 5-8
top N by duration, report results 10-4
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 10-5
traffic summary 6-11
traffic summary (extn), call types 6-14
traffic summary, call types 6-12
traffic summary, report results 10-13
traffic summary by extensions, report results 10-13
traffic summary by extensions report 6-13
U
uninhibited loading of CDR values 3-9
user reports, CAR 1-7
user reports, described 5-1
users, CAR 1-5
using 3-12
utilization
conference bridge, report results 10-22
gateway 7-6
gateway, report results 10-21
route and line group 7-8
route group, report results 10-21
route list 7-10
route list, report results 10-21
route pattern/hunt pilot 7-11
voice-mail 7-16
voice mail, report results 10-23
V
viewing 9-2
voice mail utilization, report results 10-23
voice-mail utilization report 7-16
voice quality 4-4
W
weekly reports
scheduling 3-10