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.




This Discussion