[cisco-voip] SQL query for CCM5.X to see 911 calls

[Jonathan Charles]

Yeah, that won't do anything whatsoever on CCM5

I need a run sql command.


Jonathan

On 6/13/07, Peter Pauly <ppauly at gmail.com> wrote:
> I think I got this snippet from this mailing list:
>
> SELECT     dateTimeOrigination, callingPartyNumber,
> finalCalledPartyNumber, originalCalledPartyNumber, duration
> FROM         CallDetailRecord
> WHERE     (finalCalledPartyNumber = '9911') AND (dateTimeOrigination >
> DATEDIFF([SECOND], '1/1/1970', GETDATE()) - 1209600)
>
> or
>
> /* change 14400 if necessary (Eastern daylight time) 60*60*4) */
> SELECT DATEADD(ss, (datetimeorigination - 14400), 'Jan 1, 1970 00:00:00')
>     AS datetime, callingPartyNumber, finalCalledPartyNumber,
> originalCalledPartyNumber, duration
> FROM         CallDetailRecord
> WHERE     (finalCalledPartyNumber = '9911') AND (dateTimeOrigination >
> DATEDIFF([SECOND], '1/1/1970', GETDATE()) - 1209600)
> ORDER BY dateTimeOrigination
>
> On 6/11/07, Jonathan Charles <jonvoip at gmail.com> wrote:
> > Anyone?
> >
> >
> >
> > On 5/31/07, Jonathan Charles <jonvoip at gmail.com> wrote:
> > > Anyone have one? My current SQL query for this is for SQL 2000, not informix...
> > >
> > >
> > >
> > > Jonathan
> > >
> > _______________________________________________
> > cisco-voip mailing list
> > cisco-voip at puck.nether.net
> > https://puck.nether.net/mailman/listinfo/cisco-voip
> >
>