• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 49
Veteran Member
3/16/2010 1:06 AM

Chris - Thank you for your help!

JeanneS
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.