• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Smart Notification

Smart Note Delivered Inventory

 2 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
thummel1
Veteran Member Send Private Message
Posts: 121
Veteran Member
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 Send Private Message
Posts: 1498
Veteran Member
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 Send Private Message
Posts: 1498
Veteran Member
7/22/2016 5:17 PM
The ENPDELIVERYLOG table in the same database may be something worth looking at as well.