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
    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