ip phone

Unanswered Question
Jul 18th, 2007

how can i find out who has been calling my line besides looking on the phone for missed, received or placed calls can i do this in the call manager?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
mikecotrone Wed, 07/18/2007 - 08:43

I am not sure if you are comfortable with SQL but outside of developing a watchdog app for your PC to watch your phone (we have developed for a customer) you can use SQL statements to pull this info from your Publisher's SQL db.

SELECT *, callingPartyNumber AS Expr1, dateTimeOrigination AS Expr2, DATEADD(s, dateTimeOrigination, '19700101') AS callMadeDateConverted

FROM CallDetailRecord

WHERE (callingPartyNumber = '8999')

It returns all calls made by the ext. 8999, the last column in the result set has the converted value for the dateTimeOrigination

There is also a field "CalledPartyNumber" that you can use to see who was called.




This Discussion