[cisco-voip] Call Manager Reporting

[Lelio Fulgenzi]

Depending on which version you are using, you can use a variety of SQL querries to dig this data out.

Lelio
--------------------------------------------------------------------------------
Lelio Fulgenzi, B.A.
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
...seen on a Geek Squad patch cord: "While it is the same length, this 7' crossover cable
is not regulation issue for most competitive Manhattan double dutch leagues.
  ----- Original Message ----- 
  From: Lelio Fulgenzi 
  To: Mark J 
  Cc: cisco-voip at puck.nether.net 
  Sent: Wednesday, July 16, 2008 7:41 AM
  Subject: Re: [cisco-voip] Call Manager Reporting


  0 length CDR is a CallManager service parameter. It basically says cut a CDR record every time someone dials the phone. Without this, CDRs are only cut if they are 1 second or more. 

  0 lenght CDRs will significantly add to your CDR database but it makes troubleshooting a bit easier. 

  --------------------------------------------------------------------------------
  Lelio Fulgenzi, B.A.
  Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
  (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
  "Bad grammar makes me [sic]" - Tshirt

    ----- Original Message ----- 
    From: Mark J 
    To: Lelio Fulgenzi 
    Cc: cisco-voip at puck.nether.net 
    Sent: Wednesday, July 16, 2008 12:37 AM
    Subject: Re: [cisco-voip] Call Manager Reporting


    Hi,

    Thanks for the response.

    I don't know too much about CDR, what do you mean by length 0?

    What report do I need to run to achieve this?

    Thanks for the help.


    2008/7/16 Lelio Fulgenzi <lelio at uoguelph.ca>:

      If you have 0 length CDRs enabled, you should be able to do a CDR search to that extension with a lenght of 0.

      Will give you a good idea, anyways. Not sure if it will stand up in court or a performance review. ;)

      --------------------------------------------------------------------------------
      Lelio Fulgenzi, B.A.
      Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
      (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
      "Bad grammar makes me [sic]" - Tshirt

        ----- Original Message ----- 
        From: Mark J 
        To: cisco-voip at puck.nether.net 
        Sent: Tuesday, July 15, 2008 11:35 PM
        Subject: [cisco-voip] Call Manager Reporting


        Hey guys,

        Is there a way to report on the number of missed calls on a extension?

        Basically I want to find out the number of missed calls an extension has had?

        Thanks.



------------------------------------------------------------------------


        _______________________________________________
        cisco-voip mailing list
        cisco-voip at puck.nether.net
        https://puck.nether.net/mailman/listinfo/cisco-voip





------------------------------------------------------------------------------


  _______________________________________________
  cisco-voip mailing list
  cisco-voip at puck.nether.net
  https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080716/3966b2ee/attachment.html>