Forums
Smart Notification
Smart Note Delivered Inventory
Author
Messages
thummel1
Veteran Member
Posts: 121
7/22/2016 1:25 PM
Hi,
Is there a way to easily extract a list of all the delivered Smart Notes? The purpose is to be able to identify possible issues with delivery from time to time, but also to understand Smart Note volume and activity. The only option I've found is to go to Delivered Alert History and sift through page after page. I've been doing a copy/paste into Excel so I can do further analysis, but is there a way to export this list instead?
Thank you!
Greg Moeller
Veteran Member
Posts: 1498
7/22/2016 5:02 PM
You could do it through Crystal, and basically dump the EMAILHISTORY table in the SmartNotes database.
Greg Moeller
Veteran Member
Posts: 1498
7/22/2016 5:17 PM
The ENPDELIVERYLOG table in the same database may be something worth looking at as well.