Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 13:31:56

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;