List Thresholds by User?

[rdege]

Is there a way to list all of the thresholds that a user is notified on? (either by the user, or their email address)

-Rob

[rdege]

Nevermind, I found a mysql solution:

Table: plugin_thold_contacts
id - #
data - email

Table: thold_data
id - #
name - Threshold details ($HOST on Drive)

Table: plugin_thold_threshold_contact
contact_id <=> plugin_thold_contacts.id
thold_id <=> thold_data.id


List all of the thresholds that have this $EMAIL on the notifiy list
mysql> select plugin_thold_contacts.data, thold_data.name from plugin_thold_contacts, plugin_thold_threshold_contact, thold_data WHERE plugin_thold_threshold_contact.thold_id=thold_data.id AND plugin_thold_contacts.id=plugin_thold_threshold_contact.contact_id AND plugin_thold_contacts.data="$EMAIL";


List all of the thresholds that have an entry in the "Extra Alert Emails" field
mysql> select name,notify_extra from thold_data where notify_extra!="";