Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 12:52:17

0001 #!/bin/sh
0002 
0003 lastRun=$1
0004 
0005 DB="cms_omds_lb"
0006 USER="cms_trg_r"
0007 PASSWORD_FILE=/nfshome0/centraltspro/secure/$USER.txt
0008 PASSWORD=`cat $PASSWORD_FILE`
0009 
0010 sqlplus -S ${USER}/${PASSWORD}@${DB} <<EOF
0011 set linesize 500
0012 set wrap on
0013 set heading off
0014 set pagesize 0
0015 set feedback off
0016 SELECT MIN(RUNNUMBER)
0017 FROM
0018 (
0019  SELECT B.RUNNUMBER,
0020         A.GT_KEY,
0021         B.TSCKEY,
0022         C.GT_RUN_SETTINGS_FK
0023  FROM   CMS_TRG_L1_CONF.TRIGGERSUP_CONF A,
0024         CMS_WBM.RUNSUMMARY B,
0025         CMS_GT.GT_RUN_SETTINGS_KEY_HISTORY C
0026  WHERE  A.GT_KEY IS NOT NULL
0027  AND    B.TSCKEY IS NOT NULL
0028  AND    C.GT_RUN_SETTINGS_FK IS NOT NULL
0029  AND    A.TS_KEY = B.TSCKEY
0030  AND    B.RUNNUMBER = C.RUN_NUMBER
0031  AND    C.RUN_NUMBER > ${lastRun}
0032 )
0033 ;
0034 EOF
0035 
0036 exit