CDR/Archiving Reporting Tools RRS feed

  • General discussion

  • 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!!!!


    Tuesday, November 6, 2007 11:29 PM

All replies

  • Well Microsoft is using MOM to generate reports.

    I know this is not really fair




    Tuesday, November 13, 2007 11:27 AM
  • 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


    Wednesday, November 14, 2007 6:40 AM
  • 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.



    Peyton McManus



    Wednesday, November 28, 2007 10:45 PM
  • 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.



    Friday, November 30, 2007 12:26 AM
  • 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:


    Bruno Estrozi - MCSE/MCTS/MCITP - Unified Communications Specialist
    Thursday, June 25, 2009 6:35 PM