Hi Mark
Many thanks for your advises.
I have done some test on varies calls & forwarded types, here is my findings in the table of InteractionSummary:
1. all values in Direction field are greater or equal to 1. Therefore this field shouldn't be the indicator to identify forwarded calls
2. all values in nTransfer & nEcternal fields are 0. Therefore these 2 fields are not either.
3. the only possible way I can figure out is to look at the difference between DNIS_LocalID (this is the user extension number, for example, my extension no.) and LastLocalNumber (in which is the destination number that the call forwarded to). If they are different, then the call was forwarded.
However problems come up. If I forward any calls to my mobile or external phone numbers, the DNIS_LocalID and LastLocalNumber are the same, all showing my extension number. I guess the system couldn't recognize any forwarded external numbers, except internal extension.
My conclusion is that the current version of phone system doesn't have the data or ability to let user to trace down any external forwarded calls.
The funny thing is that if an external forwarded call has been picked up (answered), you can see that record in Interaction Desktop screen. However you will never find this record in the database. I have tested this many times, all answered external forwarded call records are not appearing in the database. Not so sure why the system does this. Looks like that mission is impossible.
Anyway, thank you very much again Mark.
Frank
------------------------------
Frank Wei
Mosman Municipal Council
------------------------------
Original Message:
Sent: 01-15-2019 10:01
From: Mark Tatera
Subject: forwarded call Indicator in database
Frank,
Go check out the InteractionSummary table. There are some n Columns which you can look at to figure out if calls were transferred. Specifically look at nTransfer and nExternal. If both of them are greater than 0 then it should be an externally transferred call. If you want internal calls pick Direction = 1. Usually when I'm looking for calls like this I will make a test call which meets the criteria and then find that call in the InteractionSummary table to investigate how the call looks.
Thanks,
------------------------------
Mark Tatera
ConvergeOne
Opinions are my own and not the views of my employer. Any suggestions or programming changes I suggest come with no warranty and should be tried at your own risk.
Original Message:
Sent: 01-13-2019 19:16
From: Frank Wei
Subject: forwarded call Indicator in database
Hi
Does anyone know what the forwarded call indicator is in the database? I need to provide data to show how many incoming calls were forwarded to mobile phone, landline phone, extension, etc for a user within period of time. Therefore I need to get that indicator first to identify what call has been forwarded.
I have gone through some tables or views, for example, calldetail_viw, but couldn't find any. Please help.
Many thanks
Frank
#Reporting/Analytics
------------------------------
Frank Wei
Mosman Municipal Council
------------------------------