Author: Colm Carew

Script Report (script_report) - This is where the code for the reports is stored. It contains the report name. type (table,line, etc.) the date is was created, the report width and report height.

Report Variable (report_variable) = This determines what variables a report has

Scheduled Config (scheduled_config) - This determines if a report will be ran and emailed out at certain date/times

Reporting Shiro User (reporting_shiro_user) - These are the users within the reporting manager

Reporting Shiro Role (reporting_shiro_role) - These are the roles within the reporting manager

Search for columns in a Database -

select column_name, table_name from information_schema.COLUMNS where column_name like'%enable_ems%' order by table_name;

Using MySQL, generate a query that gets all reports, what variables the report has, if the report is scheduled, who gets emailed for that schedule