The is not really a voice question but one that may be an issue for folks implementing a Cisco VoIP solution.
Has any one looked into doing regular extracts of the CDR data for analysis? I am trying to setup a DTS export routine that will use an SQL query to extract a subset of fields. The part I am stuck on now is the WHERE clause in which I would like to extract all of yesterdays records. The DateOrigination field is stored as UTC since 1970,1,1. The troubleshooting guide shows an excel calculation but I need the MSSQL7 to do the same thing. I would like to convert the field to a date that can be compared with the value returned from the GETDATE function (minus 1 day). Any one else looked at this yet?
This should be possible by extrapolating the integer value of DATE(1970,1,1) which is 25569 and knowing the number of seconds in one day which is 86400.
However, is it worth the time taken to produce these types of custom queries when ART (Administrative Reporting Tool) is already available with CallManager and provided by Cisco in the Software Center?
Download, instructions, ART service pack, release notes, etc at:
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.