PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/22/2016 1:17 PM by  Greg Moeller
Smart Note Delivered Inventory
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(183 points)
Veteran Member
Posts:101


Send Message:

--
07/22/2016 9:25 AM
    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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    07/22/2016 1:02 PM
    You could do it through Crystal, and basically dump the EMAILHISTORY table in the SmartNotes database.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    07/22/2016 1:17 PM
    The ENPDELIVERYLOG table in the same database may be something worth looking at as well.
    You are not authorized to post a reply.