mikecotrone Wed, 07/18/2007 - 08:43
User Badges:

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


Actions

This Discussion