[cisco-voip] need to pull info out the cdr tables

[Wes Sisk]

sql does this for you.  some of my favorite troubleshooting queries:

SELECT DATEADD(ss, datetimeorigination, 'Jan 1, 1970 00:00:00')
    AS datetime, callingPartyNumber, originalcalledpartynumber,
    finalcalledpartynumber, origcause_value,
    destcause_value
FROM calldetailrecord
ORDER BY datetimeorigination

most recent record:
SELECT DATEADD(ss, datetimedisconnect, 'Jan 1, 1970 00:00:00')
    AS datetimedisc, callingPartyNumber, originalcalledpartynumber,
    finalcalledpartynumber, origcause_value,
    destcause_value
FROM calldetailrecord where datetimedisconnect = (select 
max(datetimedisconnect) from calldetailrecord)
ORDER BY datetimeorigination

/Wes

James Grace wrote:
>
> This is exactly what I needed.  Thank you  guys.  Hey is there 
> something out there, a tool that allow me to convert multiple epoch 
> time. Like in a spread sheet or text file
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* Brian Henry [mailto:Brian.Henry at apptis.com]
> *Sent:* Thursday, February 16, 2006 3:38 PM
> *To:* Jonathan Charles; James Grace
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* RE: [cisco-voip] need to pull info out the cdr tables
>
>  
>
> That is correct or another example.
>
>  
>
> select dateTimeOrigination, origIpAddr, callingPartyNumber, 
> destIpAddr, originalCalledPartyNumber, finalCalledPartyNumber, 
> dateTimeConnect, dateTimeDisconnect, lastRedirectDn, origDeviceName, 
> destDeviceName from CallDetailRecord where callingPartyNumber = '3082'
>
>  
>
> just remember that the time is in epcho time and needs manipulated.
>
>  
>
> Brian
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* cisco-voip-bounces at puck.nether.net on behalf of Jonathan Charles
> *Sent:* Thu 2/16/2006 3:29 PM
> *To:* James Grace
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] need to pull info out the cdr tables
>
> Here is a query we run to find 911 calls, you can modify as needed:
>
> use cdr   
> SELECT     dateTimeOrigination, callingPartyNumber, 
> finalCalledPartyNumber, originalCalledPartyNumber, duration
> FROM         CallDetailRecord   
> WHERE     (finalCalledPartyNumber = '911')   
>
>
>
>
> Jonathan
>
> On 2/16/06, *James Grace* <jgrace at digitelusa.net 
> <mailto:jgrace at digitelusa.net>> wrote:
>
> Im in a crunch to get some data from the cdr records.  Currently we 
> are no able to run the cdr analyis and reporting pluging on our CM 
> pub..  major issues with the tomcat and tcd services,they wont start.  
> But all the other setting are set up and data is populating in the cdr 
> tables.  Can someone give me a basic sql query to pull out all calls 
> in and out to a particular ext.
>
>  
>
> James D. Grace
>
> **CCNP CCNA MCSE MCDBA**
>
> Sr. System Engineer / Professional Svc.
>
> **Digitel Corporation**
>
>  
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net <mailto: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
>