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

[Peter Pauly]

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
>