Page 1 of 1
View scheduled reports for all users
Posted: Thu Apr 30, 2015 3:24 am
by sureshkraj2012
Hello,
Can you help me to understand where scheduled reports are getting stored in Nagios for all users?
Re: View scheduled reports for all users
Posted: Thu Apr 30, 2015 3:56 pm
by ssax
It's in an encrypted portion of our code but it's stored in the postgresql database and run via a cron job.
Re: View scheduled reports for all users
Posted: Sat May 02, 2015 7:24 am
by sureshkraj2012
Thank you!
Could you specify the table name where report details get stored.
nagiosxi=> \dt
List of relations
Schema | Name | Type | Owner
--------+--------------+-------+----------
public | xi_auditlog | table | nagiosxi
public | xi_commands | table | nagiosxi
public | xi_events | table | nagiosxi
public | xi_incidents | table | nagiosxi
public | xi_meta | table | nagiosxi
public | xi_options | table | nagiosxi
public | xi_sysstat | table | nagiosxi
public | xi_usermeta | table | nagiosxi
public | xi_users | table | nagiosxi
Re: View scheduled reports for all users
Posted: Mon May 04, 2015 9:56 am
by ssax
Code: Select all
select * from xi_usermeta where keyname = 'scheduled_reports';