Within a Cisco Unified Communications Manager server or cluster, one instance of the CDR Repository
Manager runs on the CDR Repository server or node. It manages CDR files that are received from the
Cisco Unified Communications Manager nodes and periodically sends the files to the specified
customer/third-party billing servers via FTP/SFTP. Our PBX Data Logger polls the FTP server and retrives new data. You should add the "File" data source type and configure a FTP or SFTP connection with the FTP server.
When the file arrives on the CDR Repository server or node, the CDR Repository Manager detects it.
The system archives the file in a directory that is dedicated to the date that is indicated by the UTC
timestamp that was placed in the file name when the file was created.
If any external billing server is specified in the CDRM configuration, the system creates an empty file
in each of the corresponding folders for CAR and the billing servers, if CAR or the corresponding billing
server is activated. The CDR Agent monitors new CDR/CMR files that are generated on CallManager
servers or nodes by the call processing component. It sends the files to the CDR Repository node and
then deletes the local copy after the file is pushed out. The file sender component of the CDR Repository
Manager detects these empty files and sends the file to the destination with the specified method. If the
delivery is successful, the system removes the empty file in the destination directory.
Every Cisco Unified Communications Manager can generate one CDR file and one CMR file every
minute for up to 1 hour. You can configure the maximum disk space that is used for storage of CDR files
in the CDR Repository through provisioning.
The File Manager component of the CDR Repository Manager runs hourly. When the File Manager
runs, it deletes files with dates outside the configured preservation duration. It also checks whether disk
usage has exceeded the high water mark. If so, the system deletes the processed CDR files until the low
water mark is reached, starting with the oldest files. However, if any CDR file to be deleted was not
successfully sent to the specified billing server, the system leaves it in the CDR Repository and raises a
notification or alarm. The system creates a flag file during the configured maintenance window, which
denies access to the CDR files for the CDR onDemand Service. The system removes the flag file after
the maintenance window expires.
For detailed procedures on configuring the CDR Repository Manager and customer billing servers, see "Cisco Unified Communications Manager Call Detail Records Administration Guide"
1. Создайте новый источник данных типа "File".
2. Кликните по кнопке "Действие → Добавить...".
3. Выберите тип соединения "FTP" и настройте параметры подключения к FTP серверу на вашей АТС.
4. Подкорректируйте настройки чтения данных.
| Описание | Тип данных | Имя колонки |
|---|
| Cdr Тип записи | integer | CDRRECORDTYPE |
| Date Time Origination | integer | CALL_TIME |
| Date Time Origination | integer | CALL_TIME2 |
| Original Узел Id | integer | ORIGNODEID |
| Вызывающая сторона Number | string | CALLINGPARTYNUMBER |
| Конечный Узел Id | integer | DESTNODEID |
| Original Вызываемая сторона Number | string | ORIGINALCALLEDPARTYNUMBER |
| Final Вызываемая сторона Number | string | FINALCALLEDPARTYNUMBER |
| Pkid | string | PKID |
| Duration | integer | CALL_DURATION_S |
| Код авторизации Value | string | AUTH |
| Длительность звонка | datetime | CALL_DURATION |
| Направление | string | DIRECTION |
| Тип звонка | string | CALL_TYPE |
| Набранный номер | string | DIALED_PHONE |
| Вызывающий телефон | string | CALLER_PHONE |
| Линия | string | TRUNK |
| Расширение | string | EXT |
| Global CallID call Manager Id | integer | GLOBALCALLID_CALLMANAGERID |
| Global CallID Идентификатор вызова | integer | GLOBALCALLID_CALLID |
| Original Leg Идентификатор вызоваentifier | integer | ORIGLEGCALLIDENTIFIER |
| Original Span | integer | ORIGSPAN |
| Original Ip Addr | integer | ORIGIPADDR |
| Вызывающая сторона Unicode Login UserID | string | CALLINGPARTYUNICODELOGINUSERID |
| Original Cause location | integer | ORIGCAUSE_LOCATION |
| Original Cause value | integer | ORIGCAUSE_VALUE |
| Original Precedence Level | integer | ORIGPRECEDENCELEVEL |
| Original Media Transport Address IP | integer | ORIGMEDIATRANSPORTADDRESS_IP |
| Original Media Transport Address Port | integer | ORIGMEDIATRANSPORTADDRESS_PORT |
| Original Media Cap payload Capability | integer | ORIGMEDIACAP_PAYLOADCAPABILITY |
| Original Media Cap max Frames Per Packet | integer | ORIGMEDIACAP_MAXFRAMESPERPACKET |
| Original Media Cap g723 Bit Rate | integer | ORIGMEDIACAP_G723BITRATE |
| Original Video Cap Codec | integer | ORIGVIDEOCAP_CODEC |
| Original Video Cap Bandwidth | integer | ORIGVIDEOCAP_BANDWIDTH |
| Original Video Cap Resolution | integer | ORIGVIDEOCAP_RESOLUTION |
| Original Video Transport Address IP | integer | ORIGVIDEOTRANSPORTADDRESS_IP |
| Original Video Transport Address Port | integer | ORIGVIDEOTRANSPORTADDRESS_PORT |
| Original RSVP Audio Stat | string | ORIGRSVPAUDIOSTAT |
| Original RSVP Video Stat | string | ORIGRSVPVIDEOSTAT |
| Конечный Leg Identifier | integer | DESTLEGIDENTIFIER |
| Конечный Span | integer | DESTSPAN |
| Конечный Ip Addr | integer | DESTIPADDR |
| Final Вызываемая сторона Unicode Login UserID | string | FINALCALLEDPARTYUNICODELOGINUSERID |
| Конечный Cause location | integer | DESTCAUSE_LOCATION |
| Конечный Cause value | integer | DESTCAUSE_VALUE |
| Конечный Precedence Level | integer | DESTPRECEDENCELEVEL |
| Конечный Media Transport Address IP | integer | DESTMEDIATRANSPORTADDRESS_IP |
| Конечный Media Transport Address Port | integer | DESTMEDIATRANSPORTADDRESS_PORT |
| Конечный Media Cap payload Capability | integer | DESTMEDIACAP_PAYLOADCAPABILITY |
| Конечный Media Cap max Frames Per Packet | integer | DESTMEDIACAP_MAXFRAMESPERPACKET |
| Конечный Media Cap g723 Bit Rate | integer | DESTMEDIACAP_G723BITRATE |
| Конечный Video Cap Codec | integer | DESTVIDEOCAP_CODEC |
| Конечный Video Cap Bandwidth | integer | DESTVIDEOCAP_BANDWIDTH |
| Конечный Video Cap Resolution | integer | DESTVIDEOCAP_RESOLUTION |
| Конечный Video Transport Address IP | integer | DESTVIDEOTRANSPORTADDRESS_IP |
| Конечный Video Transport Address Port | integer | DESTVIDEOTRANSPORTADDRESS_PORT |
| Конечный RSVP Audio Stat | string | DESTRSVPAUDIOSTAT |
| Конечный RSVP Video Stat | string | DESTRSVPVIDEOSTAT |
| Date Time Connect | datetime | DATETIMECONNECT |
| Date Time Disconnect | datetime | DATETIMEDISCONNECT |
| Last Redirect Dn | string | LASTREDIRECTDN |
| Original inal Вызываемая сторона Number Partition | string | ORIGINALCALLEDPARTYNUMBERPARTITION |
| Вызывающая сторона Number Partition | string | CALLINGPARTYNUMBERPARTITION |
| Final Вызываемая сторона Number Partition | string | FINALCALLEDPARTYNUMBERPARTITION |
| Last Redirect Dn Partition | string | LASTREDIRECTDNPARTITION |
| Original Device Name | string | ORIGDEVICENAME |
| Конечный Device Name | string | DESTDEVICENAME |
| Original Call Termination On Behalf Of | integer | ORIGCALLTERMINATIONONBEHALFOF |
| Конечный Call Termination On Behalf Of | integer | DESTCALLTERMINATIONONBEHALFOF |
| Original Вызываемая сторона Redirect On Behalf Of | integer | ORIGCALLEDPARTYREDIRECTONBEHALFOF |
| Last Redirect Redirect On Behalf Of | integer | LASTREDIRECTREDIRECTONBEHALFOF |
| Original Вызываемая сторона Redirect Reason | integer | ORIGCALLEDPARTYREDIRECTREASON |
| Last Redirect Redirect Reason | integer | LASTREDIRECTREDIRECTREASON |
| Конечный Conversation Id | integer | DESTCONVERSATIONID |
| Global Идентификатор вызова ClusterID | string | GLOBALCALLID_CLUSTERID |
| Join On Behalf Of | integer | JOINONBEHALFOF |
| Comment | string | COMMENT |
| Код авторизации Description | string | AUTHCODEDESCRIPTION |
| Authorization Level | integer | AUTHORIZATIONLEVEL |
| Client Matter Code | string | CLIENTMATTERCODE |
| Original DTMF Method | integer | ORIGDTMFMETHOD |
| Конечный DTMF Method | integer | DESTDTMFMETHOD |
| Call Secured Status | integer | CALLSECUREDSTATUS |
| Original Conversation Id | integer | ORIGCONVERSATIONID |
| Original Media Cap Bandwidth | integer | ORIGMEDIACAP_BANDWIDTH |
| Конечный Media Cap Bandwidth | integer | DESTMEDIACAP_BANDWIDTH |
| Outpulsed Вызывающая сторона Number | string | OUTPULSEDCALLINGPARTYNUMBER |
| Outpulsed Вызываемая сторона Number | string | OUTPULSEDCALLEDPARTYNUMBER |
| Original Ipv4v6 Addr | string | ORIGIPV4V6ADDR |
| Конечный Ipv4v6 Addr | string | DESTIPV4V6ADDR |
| Original Video Cap Codec Channel2 | integer | ORIGVIDEOCAP_CODEC_CHANNEL2 |
| Original Video Cap Bandwidth Channel2 | integer | ORIGVIDEOCAP_BANDWIDTH_CHANNEL2 |
| Original Video Cap Resolution Channel2 | integer | ORIGVIDEOCAP_RESOLUTION_CHANNEL2 |
| Original Video Transport Address IP Channel2 | integer | ORIGVIDEOTRANSPORTADDRESS_IP_CHANNEL2 |
| Original Video Transport Address Port Channel2 | integer | ORIGVIDEOTRANSPORTADDRESS_PORT_CHANNEL2 |
| Original Video Channel Role Channel2 | integer | ORIGVIDEOCHANNEL_ROLE_CHANNEL2 |
| Конечный Video Cap Codec Channel2 | integer | DESTVIDEOCAP_CODEC_CHANNEL2 |
| Конечный Video Cap Bandwidth Channel2 | integer | DESTVIDEOCAP_BANDWIDTH_CHANNEL2 |
| Конечный Video Cap Resolution Channel2 | integer | DESTVIDEOCAP_RESOLUTION_CHANNEL2 |
| Конечный Video Transport Address IP Channel2 | integer | DESTVIDEOTRANSPORTADDRESS_IP_CHANNEL2 |
| Конечный Video Transport Address Port Channel2 | integer | DESTVIDEOTRANSPORTADDRESS_PORT_CHANNEL2 |
| Конечный Video Channel Role Channel2 | integer | DESTVIDEOCHANNEL_ROLE_CHANNEL2 |
| Incoming ProtocolID | integer | INCOMINGPROTOCOLID |
| Incoming Protocol Call Ref | string | INCOMINGPROTOCOLCALLREF |
| Outgoing ProtocolID | integer | OUTGOINGPROTOCOLID |
| Outgoing Protocol Call Ref | string | OUTGOINGPROTOCOLCALLREF |
| Current Routing Reason | integer | CURRENTROUTINGREASON |
| Original Routing Reason | integer | ORIGROUTINGREASON |
| Last Redirecting Routing Reason | integer | LASTREDIRECTINGROUTINGREASON |
| Hunt Pilot Partition | string | HUNTPILOTPARTITION |
| Hunt PilotDN | string | HUNTPILOTDN |
| Вызываемая сторона Pattern Usage | integer | CALLEDPARTYPATTERNUSAGE |
| IncomingICID | string | INCOMINGICID |
| Incoming OrigIOI | string | INCOMINGORIGIOI |
| Incoming TermIOI | string | INCOMINGTERMIOI |
| OutgoingICID | string | OUTGOINGICID |
| Outgoing OrigIOI | string | OUTGOINGORIGIOI |
| Outgoing TermIOI | string | OUTGOINGTERMIOI |
| Outpulsed Original Вызываемая сторона Number | string | OUTPULSEDORIGINALCALLEDPARTYNUMBER |
| Outpulsed Last Redirecting Number | string | OUTPULSEDLASTREDIRECTINGNUMBER |
| Was Call Queued | integer | WASCALLQUEUED |
| Total Wait Time In Queue | integer | TOTALWAITTIMEINQUEUE |
| Вызывающая сторона Number uri | string | CALLINGPARTYNUMBER_URI |
| Original inal Вызываемая сторона Number uri | string | ORIGINALCALLEDPARTYNUMBER_URI |
| Final Вызываемая сторона Number uri | string | FINALCALLEDPARTYNUMBER_URI |
| Last Redirect Dn uri | string | LASTREDIRECTDN_URI |
| Mobile Вызывающая сторона Number | string | MOBILECALLINGPARTYNUMBER |
| Final Mobile Вызываемая сторона Number | string | FINALMOBILECALLEDPARTYNUMBER |
| Original Mobile Device Name | string | ORIGMOBILEDEVICENAME |
| Конечный Mobile Device Name | string | DESTMOBILEDEVICENAME |
| Original Mobile Длительность звонка | integer | ORIGMOBILECALLDURATION |
| Конечный Mobile Длительность звонка | integer | DESTMOBILECALLDURATION |
| Mobile Тип звонка | integer | MOBILECALLTYPE |
| Original inal Вызываемая сторона Pattern | string | ORIGINALCALLEDPARTYPATTERN |
| Final Вызываемая сторона Pattern | string | FINALCALLEDPARTYPATTERN |
| Last Redirecting Party Pattern | string | LASTREDIRECTINGPARTYPATTERN |
| Hunt Pilot Pattern | string | HUNTPILOTPATTERN |
Мы предлагаем утилиту PBX Reports с разнообразными ручными и автоматизированными отчетами, с возможностью вывода на печать, в файлы Excel или PDF, или отправкой по электронной почте, встроенный веб-сервер, и другие возможности. Смотрите тут
Это стандартная функция нашего логгер, который получает и экспортирует данные SMDR или CDR в реальном времени в вашу базу данных. Проследуйте по ссылке
