View outgoing emails stored on the database.

Version 2

    Verified Product Versions

    Service Desk 2016.x

    Question

    How to view the outgoing emails stored in the database.

    Answer

    Running the following SQL script:

     

    SELECT message.tps_date_sent "Date Sent",

    recipient.tps_email_address "Sent To",

    message.tps_subject "Subject",

    message.tps_body "Body",

    message.tps_application_data "Data",

    recipient.tps_is_email_sent "Email Sent"

    FROM tps_user_message_recipient recipient,

    tps_user_message message

    WHERE recipient.tps_user_message_guid = message.tps_guid

    ORDER BY message.tps_date_sent DESC;

    Environment

    ITBM Console