For auditing purposes, some companies may need to report on the sent E-mail and Text messages out of EIOBoard. To do so, you must be running the Customer-Hosted version and have direct access to the SQL Server running EIOBoard. You should then connect with SQL Management Studio and login using Windows Authentication or the “sa” password. Contact Savance if you need the “sa” password that EIOBoard deploys with the installer.
Once connected with SQL Management Studio, you’ll want to run the following SQL query against the database:
SELECT DateTimeInserted, DateTimeProcessed, ToName, ToAddress, FromName, FromAddress, CCAddress, Subject, Message, c.ContactName AS SentByName FROM DispatchQueue dq
LEFT OUTER JOIN Users u ON u.UserSys = dq.UserSys
LEFT OUTER JOIN Contacts c ON c.ContactSys = u.ContactSys
WHERE DateTimeInserted BETWEEN ‘2012-05-01’ AND ‘2012-05-02’