EcalCondDB/sql/dump_monitoring.sql

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 a15
0007 col run_type format a15
0008 col config_tag format a15
0009 col mon_ver format a15
0010
0011 ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';
0012
0013 SELECT ri.run_num, mi.subrun_num, d.num_chan, ld.location, rt.gen_tag, rd.run_type, rd.config_tag, rd.config_ver, mvd.mon_ver,
0014        ri.run_start, ri.run_end, mi.subrun_start, mi.subrun_end, mi.db_timestamp
0015 FROM
0016 (SELECT iov_id, count(logic_id) num_chan FROM mon_pedestals_dat GROUP BY iov_id) d
0017 JOIN mon_run_iov mi ON d.iov_id = mi.iov_id
0018 JOIN mon_run_tag mt ON mt.tag_id = mi.tag_id
0019 JOIN mon_version_def mvd ON mvd.def_id = mt.mon_ver_id
0020 JOIN run_iov ri ON ri.iov_id = mi.run_iov_id
0021 JOIN run_tag rt ON rt.tag_id = ri.tag_id
0022 JOIN run_type_def rd ON rd.def_id = rt.run_type_id
0023 JOIN location_def ld ON ld.def_id = rt.location_id
0024 -- WHERE rownum < 50
0025 ORDER BY ri.run_num, mi.subrun_num;