Back to home page

Project CMSSW displayed by LXR

 
 

    


Last indexation completed on 2022-09-27 05:26:34 UTC

SQL EXPLANATION
This SQL query returns the run, subrun, SM number, crystal number, and the number of events over the low and hi threshold as written by the DQM, given a minum number of events over the low and high thresholds.
SELECT riov.run_num run, miov.subrun_num subrun, rdat.id1 SM, cv.id2 crystal, occ.events_over_low_threshold n_lo, occ.events_over_high_threshold n_hi FROM run_iov riov JOIN run_tag rtag ON rtag.tag_id = riov.tag_id JOIN location_def ldef ON ldef.def_id = rtag.location_id JOIN (SELECT iov_id, cv.id1 FROM run_dat rdat JOIN channelview cv ON cv.logic_id = rdat.logic_id AND cv.name = cv.maps_to) rdat ON rdat.iov_id = riov.iov_id JOIN mon_run_iov miov ON miov.run_iov_id = riov.iov_id JOIN mon_occupancy_dat occ ON occ.iov_id = miov.iov_id JOIN channelview cv ON cv.logic_id = occ.logic_id AND cv.name = cv.maps_to WHERE ldef.location = 'H4B' AND occ.events_over_low_threshold >= ? AND occ.events_over_high_threshold >= ? ORDER BY run, SM, crystal


SEE ALSO: README

  Name Size Date (UTC) Last indexed Description
  Name Size Date (UTC) Last indexed Description
folder Parent directory - 2022-09-27 05:18:40  
occupancy.pl 2244 bytes 2013-06-26 14:12:40 2021-02-14 13:31:47  
README 4452 bytes 2013-06-26 14:12:40 -  
sum_occupancy.pl 2621 bytes 2013-06-26 14:12:40 2021-02-14 13:31:47