• 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 Send Private Message
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 Send Private Message
Posts: 1498
Veteran Member
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 Send Private Message
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