Help me Find the email address

NICE CXone API & Integrations
1

I have a question about eservices

Agent has transferred the email ( through IWS) to external contact ( email address). how do i find this in UCS DB or interaction Database, which table has this information.

since IWS is connected to UCS DB, i was able to search the email with the contact address ( email). in the history tab when i clicked on notes it says " Forwarded to external resource on 3/20/2018 8:17:39 AM by agentid "

it doesn’t tell where it was sent to - which email address.

To investigate this i did a test and i was able to find the email where it was sent to. not sure why the first scenario i am unable to find it in the IWS, i was thinking to look into UCS DB and after searching several tables i couldn’t find.

thanks

2

It should be the to address, check at URS logs the user data of that interaction.

Enviado de meu E6633 usando Tapatalk

3

thanks for the response

it happened a while ago (15 days), so we don’t have the URS logs.

4

Hehehe well…replicate the email transfer for test and grab new logs
Worth it if it’s so urgent

Enviado de meu E6633 usando Tapatalk

5

I did a test in the prod and was able to get the logs of all four apps ( ucs, email server, urs, ixn). i was even able to find the email address i forwarded to. but i am looking for the email address in the database.

since I have access to the DB, i can query the db but i don’t know which table i need to query it to.

6

Interaction table for UCS.

Enviado de meu E6633 usando Tapatalk

7

Or in EMAILOUT table. I guess its a better choice to get which addresses the message was sent to (toaddresses, ccaddresses, and bccaddresses fields)

8

thanks for the responses