Prev
Next
Forums Performance Management Smart Notification

Crystal Report on Smart Notifications

 8 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
JeanneS
Veteran Member
Posts: 49
Veteran Member
3/4/2010 11:58 PM

    I am trying to create a crystal report based on the LBI database that lists the names of all Smart Notifications along with owner and date created.  Can anyone tell me what table I should use? 

    Thanks in advance!

     

    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
    3/5/2010 2:58 PM
      Try ENPBATREE joined to ENPUSERMAP (for the name of the owner) on USERID.
      JeanneS
      Veteran Member
      Posts: 49
      Veteran Member
      3/16/2010 1:06 AM

        Chris - Thank you for your help!

        JeanneS
        Veteran Member
        Posts: 49
        Veteran Member
        3/16/2010 1:37 PM

          Do you know which table the actual e-mail address is on?  I can't find any documentation on the LBI tables.  Thanks.

          Chris Martin
          Veteran Member
          Posts: 277
          Veteran Member
          3/16/2010 2:26 PM
            Are you referring to the email associated with each user's device?

            FYI - This site does have ERD's for LBI.
            JeanneS
            Veteran Member
            Posts: 49
            Veteran Member
            3/16/2010 11:46 PM

              Yes, I am looking for e-mail addresses associated with user devices.  I will take a look at the ERDs.  I didn't notice they were on this site.  Thanks for your help.

              Chris Martin
              Veteran Member
              Posts: 277
              Veteran Member
              3/16/2010 11:52 PM
                https://www.lawsonguru.com/Portals/0/images/tips/lbi/LBI-LSN-ERD.gif
                JeanneS
                Veteran Member
                Posts: 49
                Veteran Member
                3/20/2010 1:55 AM
                  Chris - thanks for the ERDs. They were helpful. I still can't locate the actual field where the Smart Note e-mail address is stored. I found the device name in the ENTRYSTRING field on the ENPBATREE table. Do you know what field houses the e-mail address?
                  Chris Martin
                  Veteran Member
                  Posts: 277
                  Veteran Member
                  3/22/2010 5:54 AM
                    Not 100% sure, but thinking it be in a blob field in one of the SN tables. I'll have a chance to look a bit more later this week and will let you know what I find.