We have a need for generating a report that lists blind and consultative transfer, I have currently found some information that may be useful in Routing_Client_Five_Minute table, however the information is incomplete in correlating the Agent that conducted the transfer, and the DN involved.
In the RCD (route call detail) table, the request type field can indicate the type of route request processed:
1 Pre-Routing request
2 Blind transfer or network VRU
3 Announced transfer or MCI 800 call
6 Post-Routing request
The difficulty is to then correlate the Agent and the DN info as this may require RCD to TCD mapping for the Agent leg. As a caution, this type of mapping can have the ability to negatively impact HDS performance as the join should only be performed on exported data.
I have some experience of doing this complex processing and would be very happy to share further thoughts. Please don't hesitate to contact me offline at email@example.com
whenever you would consider joining RCD and Agent data I would recommend copying the needed tables to a replica DB and run there your custom reports, just a bit of an advise, to avoid impacting on the solution performance as John rightfully warned.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...