File indexing completed on 2024-04-06 12:23:00
0001 SET ECHO OFF;
0002 SET FEEDBACK OFF;
0003 SET LINESIZE 1000;
0004 SET PAGESIZE 1000;
0005 col location format a8
0006 col gen_tag format a8
0007 col run_type format a15
0008 col monitoring_ver format a15
0009
0010 ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';
0011 SELECT location, gen_tag, run_type, monitoring_ver,
0012 count(distinct run_num) num_runs,
0013 min(run_num) min_run, min(run_start) min_start_date,
0014 max(run_num) max_run, max(run_start) max_start_date
0015 FROM (
0016 SELECT lt.location, rt.tag_id, rt.gen_tag, rt.run_type, rt.monitoring_ver,
0017 i.run_num, i.run_start, i.run_end
0018 FROM location_tag lt JOIN run_tag rt ON lt.tag_id = rt.location_id
0019 JOIN run_iov i ON i.tag_id = rt.tag_id
0020 JOIN (SELECT DISTINCT iov_id FROM mon_pedestals_dat) m ON m.iov_id = i.iov_id
0021 )
0022 GROUP BY location, gen_tag, run_type, monitoring_ver;
