[cisco-voip] Call Records in CM 3.3

Thu Mar 6 16:36:33 EST 2008

That's what I thought Ryan. But as far as I can tell the orig and final were the same based on route pattern digit manipulation. I'll double check tomorrow since this is important for our toll-bypass project and to ensure people don't get charged long distance fees for calls out our remote gateways.

Lelio
--------------------------------------------------------------------------------
Lelio Fulgenzi, B.A.
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
Java-Clavis-Domus Theorem: The ability to keep your hands on the home keys is inversely
related to the amount of caffeine ingested in the last 30 minutes. 

  ----- Original Message ----- 
  From: Ryan Ratliff 
  To: 'Matthew Loraditch' ; cisco-voip at puck.nether.net 
  Sent: Thursday, March 06, 2008 4:33 PM
  Subject: Re: [cisco-voip] Call Records in CM 3.3

  You can do a quick SQL query to check on this.  Make some PSTN call, wait a minute or two, then run this query:
  select orginalcalledpartynumber,finalcalledpartynumber from calldetailrecord where originalcalledpartynumber like '9xxxxxxxxxx' 

  Of course subsitute the actual number you dial for the 10 x's.   See if both originalcalledpartynumber and finalcalledpartynumber are the same.  I'd like to think that originalcalledpartynumber is the number the user dials at the phone and finalcalledpartynumber is the number when it gets to the destination.
  -Ryan 

------------------------------------------------------------------------------
  From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Matthew Loraditch
  Sent: Thursday, March 06, 2008 4:28 PM
  To: cisco-voip at puck.nether.net
  Subject: Re: [cisco-voip] Call Records in CM 3.3

  Thanks Lelio and Ryan, the system was setup before my time and they've got large number of route patterns and aren't on centrex so I don't want to change any of that for one app to work. I also don't think the 9 is going to the gateway oh well. Hopefully the app dev figures out how to write a proper sql query!!

  Matthew Loraditch

  Helion Automotive Technologies

  10944 Beaver Dam Road, Suite A

  Hunt Valley, MD 21030

  mloraditch at heliontechnologies.com

  410-252-8830 (office)

  443-541-1593 (fax)

  visit us at www.heliontechnologies.com

  Support Issue? Email support at heliontechnologies.com for fast assistance!

  From: Lelio Fulgenzi [mailto:lelio at uoguelph.ca] 
  Sent: Thursday, March 06, 2008 4:11 PM
  To: Ryan Ratliff; Matthew Loraditch; cisco-voip at puck.nether.net
  Subject: Re: [cisco-voip] Call Records in CM 3.3

  When I did some experimenting, it was more like whatever the route pattern has is added to CDR, if there is some digit manipulation done in the route list/group/gateway that stuff is not in the CDR.

  So for example, if you have a centrex lines that need a 9 and you have the 9 in the route pattern, it will be in your CDR. If you remove it from the route pattern and add it to the route list, then things will still work and they will not be in your CDR.

  *crossmyfingers*

  Lelio
  --------------------------------------------------------------------------------
  Lelio Fulgenzi, B.A.
  Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
  (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
  Java-Clavis-Domus Theorem: The ability to keep your hands on the home keys is inversely
  related to the amount of caffeine ingested in the last 30 minutes. 

    ----- Original Message ----- 

    From: Ryan Ratliff 

    To: 'Matthew Loraditch' ; cisco-voip at puck.nether.net 

    Sent: Thursday, March 06, 2008 3:57 PM

    Subject: Re: [cisco-voip] Call Records in CM 3.3

    Are you sending the 9 to your gateway?  If so then CM will always put that into the CDR.

    If you are not sending the 9 to the gateway then perhaps finalCalledPartyNumber will have the number minus the 9.  I don't have a server handy to test on or I'd double check.

    -Ryan 

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

    From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Matthew Loraditch
    Sent: Thursday, March 06, 2008 3:44 PM
    To: cisco-voip at puck.nether.net
    Subject: [cisco-voip] Call Records in CM 3.3

    We have an app integrating with CM, it pulls info from the sql logs and uses it to match up with its CRM records. The problem right now is CCM is recording the 9 dialed to get an outside line and the app trying to read the database only pulls the first 10 digits from the record and thus isn't matching any numbers to its own records. Is there a way to change what CCM records to eliminate the 9? The app developer is looking on their end to see what they can do, but asked me to see if we could change the way the data records.

    Any help is appreciated!

    Matthew Loraditch

    Helion Automotive Technologies

    10944 Beaver Dam Road, Suite A

    Hunt Valley, MD 21030

    mloraditch at heliontechnologies.com

    410-252-8830 (office)

    443-541-1593 (fax)

    visit us at www.heliontechnologies.com

    Support Issue? Email support at heliontechnologies.com for fast assistance!

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

    _______________________________________________
    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/20080306/03563e2a/attachment.html 