CDR/Archiving Reporting Tools

Locked CDR/Archiving Reporting Tools

  • terça-feira, 6 de novembro de 2007 23:29
     
     

    Hello fellow OCS implementors/administrators,

     

    I would like to express my extreme disappointment at the inadequecy of specialized reporting tools with the CDR / Archiving service included with OCS 2007.

     

    Seriously Microsoft, how do you think customers are going to use the feature? What do you think customers are going to expect to be able to retrieve out of the data store? Do you even know?

     

    Customers are capturing this data for a reason. To conveniently keep a track of usage and to retrieve conversations (not just individual IM's) for compliance or HR reasons. Some people may even want to retrieve some content if they forgot to turn on their personal archiving and need to access a historical conversation.

     

    Microsoft, you've really dropped the ball on this one. The reporting tool included in the resource kit looks like a developer knocked something up in a few spare minutes just to prove the functionality of the service they were developing (CDR). There are a few canned SQL queries in there which whet the apetite, but it is unfair to expect that every company out there has the time or experience to develop custom queries when the majority of customers will want the same results/reports. To top it all off there is NO schema documentation for the database (that I can find), so even if you do have resources available with the necessary skills, there's an added cost while you try to sort it out.

     

    So basically for those that can customize reports, there is an additional several thousand dollars in expense developing reports. Multiply that by the thousands of companies that will probably implement this.

     

    And for those that don't have the skills, well tough s**t!

     

    It's just not good enough Microsoft.

     

    Your competition is right on top of this and the influencers/recommenders out there know it!!!!

     

Todas as Respostas

  • terça-feira, 13 de novembro de 2007 11:27
     
     

    Well Microsoft is using MOM to generate reports.

    I know this is not really fair

     

    Deli

     

  • quarta-feira, 14 de novembro de 2007 06:40
     
     

    Hi,

     

    I have something that I am writing for myself, shoot me an email and I'll send you some info.

     

    Send the email to imwire [at] eventure.biz

     

    Vivek Garg

    http://imwire.eventure.biz

  • quarta-feira, 28 de novembro de 2007 22:45
     
     

    I apologize for the plug, but Instant Technologies has developed a very nice, easy to use, application to displaying a lot of the information that you may require from the logs.  Our product supports both LCS 2005 and OCS 2007.  Information is available www.instant-tech.com

     

    Here is a direct link to the product: http://www.instant-tech.com/instant.nsf/root/lcsav.htm

     

    Specifically, our application is an asp.net application that assembles the log tables into a nicel formatted set of views for users to quickly see their conversations.  We have recently ported this to OCS 2007.  We are also looking at providing additional searching and reporting.

     

    We'd be happy to help answer any questions.

     

    Regards,

    Peyton McManus

    www.instant-tech.com

     

  • sexta-feira, 30 de novembro de 2007 00:26
     
     
    Hi Peyton,

    That looks good. I will make my client aware of your application as I think it will fit nicely into their reporting system.

    Rgds,

    Morris

  • quinta-feira, 25 de junho de 2009 18:35
     
     
    Hello folks,

    I make a sql query to retrive all call logs and put on CDR Report Tool of the OCS ResKit. Take a look:

    http://brunoestrozi.blogspot.com/2009/06/ocs-queries-para-cdr.html


    Bruno Estrozi - MCSE/MCTS/MCITP - Unified Communications Specialist