[cisco-voip] DestIPAddr field in CDR record

[Lelio Fulgenzi]

The CAR/ART tool , whatever you call it.

--------------------------------------------------------------------------------
Lelio Fulgenzi, B.A.
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
"Buffalo buffalo Buffalo buffalo buffalo buffalo Buffalo buffalo."      WJR
  ----- Original Message ----- 
  From: CarlosOrtiz at bayviewfinancial.com 
  To: Lelio Fulgenzi 
  Cc: cisco-voip at puck.nether.net ; cisco-voip-bounces at puck.nether.net 
  Sent: Wednesday, August 01, 2007 9:27 AM
  Subject: Re: [cisco-voip] DestIPAddr field in CDR record



  Which tool? 




        "Lelio Fulgenzi" <lelio at uoguelph.ca> 
        Sent by: cisco-voip-bounces at puck.nether.net 
        08/01/2007 09:23 AM 
       To <CarlosOrtiz at bayviewfinancial.com>  
              cc cisco-voip at puck.nether.net  
              Subject Re: [cisco-voip] DestIPAddr field in CDR record 

              

       



  sorry, i was using the tool. it probably did the conversion for me. 
    
  --------------------------------------------------------------------------------
  Lelio Fulgenzi, B.A.
  Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
  (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
  "Buffalo buffalo Buffalo buffalo buffalo buffalo Buffalo buffalo."      WJR 
  ----- Original Message ----- 
  From: CarlosOrtiz at bayviewfinancial.com 
  To: Lelio Fulgenzi 
  Cc: cisco-voip at puck.nether.net 
  Sent: Wednesday, August 01, 2007 9:16 AM 
  Subject: Re: [cisco-voip] DestIPAddr field in CDR record 


  I see a 9 digit numeric number.   Are you looking in the CDR database, calldetailrecord table?  I started searching the archives and I did find this email which you posted a reply to ! 

                    lelio at uoguelph 

                    Sep 27, 2006, 5:00 PM 

                    Post #2 of 4 (258 views) 
                    Permalink  
                          Re: CDR IP Address Conversion Remove Highlighting [In reply to]  

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



                    found this using google... 

                    http://www.cisco.com/en/US/products/sw/voicesw/ps556/prod_troubleshooting_guide_chapter09186a0080382d82.html#wp1003527 


                    ----- Original Message ----- 
                    From: STEVEN CASPER 
                    To: cisco-voip[at]puck.nether.net 
                    Sent: Wednesday, September 27, 2006 7:55 PM 
                    Subject: [cisco-voip] CDR IP Address Conversion 



                    Does anyone have a tool or formula they could share that can be used to 
                    convert the signed decimal value in the CDR database to an IP address? 

                    Thanks! 
                    Steve  

             

       







        "Lelio Fulgenzi" <lelio at uoguelph.ca> 
        Sent by: cisco-voip-bounces at puck.nether.net 
        08/01/2007 09:10 AM 
       
              To <cisco-voip at puck.nether.net>, <CarlosOrtiz at bayviewfinancial.com>  
              cc  
              Subject Re: [cisco-voip] DestIPAddr field in CDR record 


              

       




  I see dotted decimal form a.b.c.d 
   
  what do you see? 
   
  --------------------------------------------------------------------------------
  Lelio Fulgenzi, B.A.
  Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
  (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
  "Buffalo buffalo Buffalo buffalo buffalo buffalo Buffalo buffalo."      WJR 
  ----- Original Message ----- 
  From: CarlosOrtiz at bayviewfinancial.com 
  To: cisco-voip at puck.nether.net 
  Sent: Wednesday, August 01, 2007 8:56 AM 
  Subject: [cisco-voip] DestIPAddr field in CDR record 


  When viewing the DestIPAddr for a call in the CDR database of the calldetailrecord table a numeric number is shown.  Anyone know how to convert this to IP address format? 

  Carlos 


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

  _______________________________________________
  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_______________________________________________
  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/20070801/ee4c7ad2/attachment-0001.html