Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

ip phone

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?

1 REPLY
Community Member

Re: ip phone

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.

HTH,

Mike

94
Views
0
Helpful
1
Replies
CreatePlease to create content