Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
1576
Views
12
Helpful
3
Replies

Help to build a SQL query in CDR

Go to solution
mirtenmous
Level 1
Level 1

‎09-17-2007 03:27 AM - edited ‎03-14-2019 11:34 PM

I need to do a sql query that shows me calls receveid for a dial number and were transfered from another dial number in a determinate date and time.

Can anybody help me?.

Labels:
0 Helpful
1 Accepted Solution

Accepted Solutions

Go to solution
benhanson
Level 1
Level 1

‎09-27-2007 12:16 PM

Here's my basic "everything to and from a given number" query. This is at least a starting point for you.

SELECT DATEADD([second], dateTimeOrigination - 32400, CONVERT(DATETIME, '1970-01-01 00:00:00', 102)) AS Called_At, callingPartyNumber AS Extension,

originalCalledPartyNumber, finalCalledPartyNumber, DATEADD([second], dateTimeConnect - 32400, CONVERT(DATETIME, '1970-01-01 00:00:00', 102))

AS TimeConnect, DATEADD([second], dateTimeDisconnect - 32400, CONVERT(DATETIME, '1970-01-01 00:00:00', 102)) AS Time_Disconnect, duration,

callingPartyNumberPartition, originalCalledPartyNumberPartition

FROM CallDetailRecord

WHERE (originalCalledPartyNumber = '12345678') OR

(callingPartyNumber = '12345678')

ORDER BY dateTimeOrigination DESC

View solution in original post

3 Replies 3

Go to solution
pklos
Level 4
Level 4

‎09-17-2007 08:05 AM

If this call is transfered from another number you can find it by filtering on lastRedirectDn field.

--

regards,

pk

Go to solution
mirtenmous
Level 1
Level 1
In response to pklos

‎09-17-2007 11:35 PM

I think it is not a good answer for my knowledge building SQL queries.

Thanks.

0 Helpful

Go to solution
benhanson
Level 1
Level 1

‎09-27-2007 12:16 PM

Here's my basic "everything to and from a given number" query. This is at least a starting point for you.

SELECT DATEADD([second], dateTimeOrigination - 32400, CONVERT(DATETIME, '1970-01-01 00:00:00', 102)) AS Called_At, callingPartyNumber AS Extension,

originalCalledPartyNumber, finalCalledPartyNumber, DATEADD([second], dateTimeConnect - 32400, CONVERT(DATETIME, '1970-01-01 00:00:00', 102))

AS TimeConnect, DATEADD([second], dateTimeDisconnect - 32400, CONVERT(DATETIME, '1970-01-01 00:00:00', 102)) AS Time_Disconnect, duration,

callingPartyNumberPartition, originalCalledPartyNumberPartition

FROM CallDetailRecord

WHERE (originalCalledPartyNumber = '12345678') OR

(callingPartyNumber = '12345678')

ORDER BY dateTimeOrigination DESC

Customers Also Viewed These Support Documents