To provide relevant statistics on VC's, I am looking for a link between the objSystemCallLog record and the E164 Alias from the MCU MSE-8500.
The data is available in the field StrValue from the field_SystemField Table, this StrValue field is linked to the objSystem_ID (488 for our MSE) and the field_Field_Id = 121 for the E164 Alias but this one can have several FieldIndex values each value represent the Conference Number (120 differents values in our case).
I need to have the right E164 Alias in the CDR record for a MCU call, I don't find a link between the CDR record and the MCU Conference Number, except in the RemoteSite field but only in the call part where the remote site is the MCU, not in the call part from the MCU to the Endpoint.
Note, Cisco does not support direct access to the database in this fashion as this information is not documented nor is it guaranteed to be consistent.
Just thinking off the top of my head.. I don't think the data you are after (getting the alias for the conference in the CDR record) exists in the call records. The bridge knows there is a conference.. the dial-in alias for it is just a property that is just a secondary property.
you might be better off trying to follow the conference back to the scheduledCall entry for the row as that would know which meeting port was used for the call.. and meeting port to alias could be worked out.
If you can tell us what you are trying to do.. there may be a different path available. Like using the gatekeeper logs instead of the MCU, etc.
I'm still not really following what you are after. Basically everything you highlighted in that report is what the CDR records are.
The difference is the CDR reports FOR A DEVICE do not report what alias was used in the incoming call. If you could explain what you are trying to do (your need, not your proposed solution), we can better help guide you through what is available.
If you want both incoming and outgoing aliases... the gatekeeper log is what you want to pursue as it reports both.
What you are looking for is what we do, (The Visual Environment Ltd, www.thevisualenvironment.com
Our unique software (video-miles®) automatically pulls all the relevant cdr data (and more) you and other users require from TMS/SQL and other manufacturers associated management tools and infrastructure. The software automatically filters and matches multiple identfiers for point to point and or MCU calls in a VC/Telepresence environment. The results for our Customers can then be viewed in graphic and or various report options
If we can help further and or you require a demonstration of the unique video-miles® software please let me know: email@example.com
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
[toc:faq]CUCM Database Replication is an area in which Cisco customers
and partners have asked for more in-depth training in being able to
properly assess a replication problem and potentially resolve an issue
without involving TAC. This document discusse...