|
Home > Archive > Voice over IP Cisco > June 2007 > SQL query for CCM5.X to see 911 calls
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL query for CCM5.X to see 911 calls
|
|
| Jonathan Charles 2007-06-01, 1:11 am |
| Anyone have one? My current SQL query for this is for SQL 2000, not informix...
Jonathan
| |
| Jonathan Charles 2007-06-11, 7:11 pm |
| Anyone?
On 5/31/07, Jonathan Charles <jonvoip@gmail.com> wrote:
> Anyone have one? My current SQL query for this is for SQL 2000, not informix...
>
>
>
> Jonathan
>
| |
| Peter Pauly 2007-06-13, 7:11 pm |
| 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@gmail.com> wrote:
> Anyone?
>
>
>
> On 5/31/07, Jonathan Charles <jonvoip@gmail.com> wrote:
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
| |
| Jonathan Charles 2007-06-14, 1:11 am |
| Yeah, that won't do anything whatsoever on CCM5
I need a run sql command.
Jonathan
On 6/13/07, Peter Pauly <ppauly@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@gmail.com> wrote:
>
|
|
|
|
|