-- Call Detail Reporting Guide -- September 2000 -- Page 2 --
1. INTRODUCTION TO CALL DETAIL RECORDING ....................................................................... 3
1.1 CDR A
PPLICATIONS
.............................................................................................................................. 3
1.2 C
ALL
C
ENTER
E
VENTS AND
CDR ......................................................................................................... 3
1.3 M
ANAGEMENT
O
BJECTIVES
.................................................................................................................. 4
2.0 ALTIGEN’S REPORTING SOLUTIONS........................................................................................... 5
2.1 B
UNDLED
R
EPORTING
S
OLUTION
.......................................................................................................... 5
2.2 R
EPORTS
A
VAILABLE WITH
OE 4.0
VIA
T
RI
V
IUM
C
ALL
A
NALYST
....................................................... 5
BASIC REPORTS ........................................................................................................................................ 5
2.3 C
ALL
D
ETAIL
R
ECORDING
- P
AST AND
P
RESENT
.................................................................................. 7
2.4 N
O
OE 3.5 M
IGRATION
P
ATH
............................................................................................................... 7
2.5 C
AUTIONS
C
ONCERNING
SMDR ........................................................................................................... 7
2.6 R
EAL
T
IME AND
C
ENTRALIZED
CDR A
PPLICATIONS
............................................................................ 7
3. 0 BACKING UP AND INSTALLING ALTIWARE’S CDR RECORDS............................................ 8
3.0 EXTERNAL LOGGER SERVICE....................................................................................................... 8
3.1 E
XTERNAL
CDR L
OGGER
I
NSTALLATION
G
UIDE
.................................................................................. 9
3.2 I
NSTALLING
E
XTERNAL
CDR L
OGGER
S
ERVICE TO
SQL S
ERVER
....................................................... 9
3.3 S
ET
-
UP THE
L
OGGER AND
W
ATCH
D
OG
S
ERVICES
............................................................................... 10
3.4 A
CTIVATE
E
XTERNAL
CDR L
OGGING IN
A
LTI
W
ARE
.......................................................................... 10
3.5 V
ERIFY
SQL L
OGGING
A
CTIVITY
....................................................................................................... 10
3.6 SQL B
ACKUP AND
M
AINTENANCE
...................................................................................................... 10
4.0 CALL DETAIL REPORTING DATA SCHEMA............................................................................. 11
4.1 C
ONFIGURATION
A
REAS AFFECTING
CDR
INFORMATION
................................................................... 15
4.2 E
XAMPLE
C
ALL
S
EQUENCES AND THEIR EFFECT ON
CDR
RECORDS
. .................................................. 16
4.3 R
EPORTING
F
IELDS
G
LOSSARY
........................................................................................................... 17
APPENDIX A: SUMMARY OF REPORT FIELDS – EXAMPLE METHODS OF CALCULATION
...................................................................................................................................................................... 23
APPENDIX B - EXAMPLE REPORTS.................................................................................................. 29