• 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
Posts: 121
Veteran Member
New Poster
New Poster
Congrats on posting!
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
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
7/22/2016 5:17 PM
The ENPDELIVERYLOG table in the same database may be something worth looking at as well.