AWR dbms_workload_repository ash_global_report_text extract text from output
The DB time can be queried from dba_hist_sys_time_model.
resmgr: cpu quantum can be queried from dba_hist_system_event.
snap_id can be matched to time periods through dba_hist_snapshot.
Instead of generating a report then parsing it, use the above views to query what you need.