Nagios Support Forum

Code: Select all

nagiosxi=# \d xi_usermeta
                                        Table "public.xi_usermeta"
   Column    |          Type          |                             Modifiers
-------------+------------------------+-------------------------------------------------------------------
 usermeta_id | integer                | not null default nextval('xi_usermeta_usermeta_id_seq'::regclass)
 user_id     | integer                | not null
 keyname     | character varying(255) | not null
 keyvalue    | text                   |
 autoload    | smallint               | default (0)::smallint
Indexes:
    "xi_usermeta_pkey" PRIMARY KEY, btree (usermeta_id)
    "xi_usermeta_user_id_key" UNIQUE, btree (user_id, keyname)
    "xi_usermeta_autoload_idx" btree (autoload)

Code: Select all

nagiosxi=# select * from xi_usermeta where keyname='notification_messages';
 usermeta_id | user_id |        keyname        |                                                                          keyvalue                                                                          | autoload
-------------+---------+-----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------+----------
         182 |      18 | notification_messages | a:2:{s:5:"email";a:2:{s:4:"host";a:2:{s:7:"subject";s:46:"%type% Host Alert - %hostalias% is %hoststate%";s:7:"message";s:188:"***** Nagios XI Alert *****

Notification Type: %type%
Host: %host%
State: %hoststate%
Address: %hostaddress%
Info: %hostoutput%
Date/Time: %datetime%

Nagios URL: %xiserverurl%
";}s:7:"service";a:2:{s:7:"subject";s:62:"%type% Service Alert - %hostalias%/%service% is %servicestate%";s:7:"message";s:222:"***** Nagios XI Alert *****

Notification Type: %type%

Service: %service%
Host: %hostalias%
Address: %hostaddress%
State: %servicestate%
Info:
%serviceoutput%
Date/Time: %datetime%

Nagios URL: %xiserverurl%
";}}s:10:"mobiletext";a:2:{s:4:"host";a:2:{s:7:"subject";s:17:"%type% Host Alert";s:7:"message";s:130:"Host: %host%
State: %hoststate%
Address: %hostaddress%
Info: %hostoutput%
Date/Time: %datetime%

Nagios URL: %xiserverurl%
";}s:7:"service";a:2:{s:7:"subject";s:20:"%type% Service Alert";s:7:"message";s:162:"Service: %service%
Host: %hostalias%
Address: %hostaddress%
State: %servicestate%
Info:
%serviceoutput%
Date/Time: %datetime%

Nagios URL: %xiserverurl%
";}}} |        1
(1 row)

Code: Select all

nagiosxi=# SELECT * FROM xi_usermeta LEFT JOIN xi_users USING (user_id) WHERE keyname='notification_messages' AND username='nagiosadmin';