Cisco UC560. SMDR/CDR data format and connection settings


This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not applicable for other software titles.

DescriptionData typeColumn name
Date Time OriginationintegerCALL_TIME
Call IDstringFLAG1
CDR typestringFLAG2
Call leg typestringFLAG3
H323 Call IDstringFLAG4
Peer addressstringPEER_ADDR
Peer subaddressstringPEER_SUB_ADDR
Setup timedatetimeSETUP_TIME
Alert timedatetimeALERT_TIME
Start timedatetimeSTART_TIME
End timedatetimeEND_TIME
Call durationdatetimeCALL_DURATION
Call duration (s)integerCALL_DURATION_S
Disconnect causestringFLAG5
Disconnect textstringFLAG6
H323 call originstringCALL_ORIGIN
Charged unitsstringCHARGED_UNITS
Info typestringINFO_TYPE
Packets outstringPAKS_OUT
Bytes outstringBYTES_OUT
Packets instringPAKS_IN
Bytes instringBYTES_IN
SourcestringSRC
Source 2stringSRC2
DestinationstringDEST
Feature namestringFEATURE_ID_FIELD1
Feature invocation timestringFEATURE_ID_FIELD2
Calling numberstringFEATURE_ID_FIELD3
Called numberstringFEATURE_ID_FIELD4
FrsstringFEATURE_ID_FIELD5
Call typestringCALL_TYPE2
ExtensionstringEXT
DirectionstringDIRECTION
Call typestringCALL_TYPE
Caller phonestringCALLER_PHONE
Ring durationdatetimeRING
Dialed phonestringDIALED_PHONE

Note: Products and companies mentioned here are used only for definition and identification purposes and can be trademarks and/or registered trademarks of the respective companies.