ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 1F0480A8258E6E8BE0636ADA860A3BB8 ORB User Name Y select ou.id value, xxen_orb_util.orb_user(ou.id) description from xxorb.orb_user ou US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 1F150D78A8B1A7D9E0636ADA860A5F62 select ors.run_id, ors.component run_component, ors.report_id, ors.report_name, ors.report_type, ors.run_by, xxen_util.client_time(ors.created_date)created_date, xxen_util.client_time(ors.completion_time)completion_time, xxen_util.time(ors.time_in_seconds)execution_time, ors.output_type, ors.error_message, ors.rows_retrieved, round(ors.rows_retrieved/decode(ors.time_in_seconds,0,0.25,ors.time_in_seconds),2) rows_second, ors.process_description , ors.process_outputfilepath, ors.process_output_type, ors.process_logfilepath, ors.process_phase, ors.process_status, xxen_util.client_time(ors.process_start_time)process_start_time, xxen_util.client_time(ors.process_end_time)process_end_time, ors.schedule_name, xxen_util.client_time(ors.next_schedule_time)next_schedule_time, xxen_util.client_time(ors.previous_start_time)previous_start_time, ors.schedule_timezone, ors.schedule_trigger_type, ors.last_modified_by, xxen_util.client_time(ors.last_modified_date)last_modified_date, ors.sql_query from (select ors.id run_id, ors.component, orv.report_id, orv.report_name, orv.report_type, xxen_orb_util.orb_user(ors.run_by) run_by, cast(ors.created_date as date) created_date, cast(ors.run_date as date) run_date, cast(ors.completion_time as date) completion_time, round((cast(ors.completion_time as date) - cast(ors.created_date as date)) * 86400,2) time_in_seconds, ors.output_type, ors.error_message, ors.rows_retrieved, ors.sql_query, op.description process_description , op.outputfilepath process_outputfilepath, op.outputtype process_output_type, op.logfilepath process_logfilepath, op.phase process_phase, op.status process_status, cast(op.start_time as date) process_start_time, cast(op.end_time as date) process_end_time, os.name schedule_name, cast(os.next_fire_time as date)next_schedule_time, cast(os.prev_fire_time as date)previous_start_time, os.time_zone schedule_timezone, os.trigger_type schedule_trigger_type, xxen_orb_util.orb_user(ors.last_modified_by)last_modified_by, cast(ors.last_modified_date as date) last_modified_date from xxorb.orb_report_stats ors, xxorb.orb_report_v orv, xxorb.orb_process op, xxorb.orb_schedule os where orv.report_id=ors.report_id and ors.process_id=op.id(+) and op.schedule_id=os.id(+) )ors where 1=1 order by ors.run_date desc Y US ORB Report Execution History Execution history of Orbit reports. This can be used when migrating from Orbit Reporting to Blitz Report, to analyze which Orbit reports were previously used by the business. ORBIT 1=1 1 10 1=1 ors.report_name=:report_name LOV custom Y select orv.report_name value, orv.report_desc description from xxorb.orb_report_v orv US Report Name 2 20 1=1 ors.run_by=xxen_orb_util.orb_user(:created_by) LOV ORB User Name 1F0480A8258E6E8BE0636ADA860A3BB8 Y select ou.id value, xxen_orb_util.orb_user(ou.id) description from xxorb.orb_user ou US Submitted by User 3 30 1=1 ors.report_id in ( select orv.report_id from xxorb.orb_report_v orv where lower(orv.report_name) like lower(:report_name)||'%' ) Char US Report Name starts with 4 40 1=1 ors.created_date>sysdate-:days Number 10 US Started within Days 5 50 1=1 ors.created_date>=:start_date_from DateTime US Start Date From 6 60 1=1 ors.created_date<=:start_date_to DateTime :$flex$.start_date_from+86399/86400 US Start Date To 7 70 1=1 ors.component=:run_type LOV custom Y select 'Browser' value, null description from dual union all select 'Scheduler' value, null description from dual union all select 'Report' value, null description from dual US Run through Component 8 80 1=1 ors.error_message is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Yes US Show Errored Only 9 1=1 ors.error_message is null US Show Errored Only 10 90 1=1 ors.run_by<>xxen_orb_util.orb_user(:exclude_user) LOV ORB User Name 1F0480A8258E6E8BE0636ADA860A3BB8 Y select ou.id value, xxen_orb_util.orb_user(ou.id) description from xxorb.orb_user ou US Exclude Submissions from User :$flex$.start_date_from Start Date From Y Start Date To