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

[Jonathan Charles]

Oh, yeah, forgot about that...

Go here when you get the results to convert the time:

http://www.forestasia.com/tools/epoch.asp

BTW, Epoch time is the number of seconds that have passed since January 1st,
1970... apparently this is the year 0 for Epoch time.



J

On 2/16/06, Brian Henry <Brian.Henry at apptis.com> wrote:
>
>  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> 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
> > https://puck.nether.net/mailman/listinfo/cisco-voip
> >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20060216/a4e166cd/attachment.html