View scheduled reports for all users

[sureshkraj2012]

Hello,

Can you help me to understand where scheduled reports are getting stored in Nagios for all users?

[ssax]

It's in an encrypted portion of our code but it's stored in the postgresql database and run via a cron job.

[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

[ssax]

Code: Select all

select * from xi_usermeta where keyname = 'scheduled_reports';