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

Email Delivery Device - Where is the email address stored in database

 2 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
Tim
Basic Member
Posts: 12
Basic Member
7/22/2011 1:38 PM
Hi,

I have access to query the SQL Server database that holds the meta information for our smart notifications.   I am trying to find the table/column that holds the email address of a registered delivery device. 

Does anyone know the name of the table and column that holds this information?   I have not had any success in finding it.  I thought it might be in the ENPBATREE table.  However, I am not seeing the delivery device that I created for myself.

Regards,

Tim
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/2011 6:04 PM
Tim: I just did a quick look, and couldn't find the delivery device(s) either... but have you checked the LBI schemas on the ERDs tab?
That may give you a better handle on things.

Another possibility is that they are stored as blobs on one of the tables and I've never found a good way of getting that type of info.
Tim
Basic Member
Posts: 12
Basic Member
8/12/2011 5:14 PM
Hey Greg,

They are stored in a BLOB column! Here is a query I used to find it:

SELECT
*,
CONVERT(VARCHAR(2000), SUBSTRING(ATTRBINARYVALUE, 1, 1000)) as DEVICE_ADDRESS_FROM_BLOB /* SET 1000 to an acceptable value */
FROM
dbo.ENPENTRYATTR
where ATTRCATEGORY = 105 /* set the attrcategory to the "Devices" category. */
and ATTRID = 10015 /* set to the attrid for the "definition" attribute for the Devices category */


HTH

Tim