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