ViewVC Help
View File | Revision Log | Show Annotations | Root Listing
root/cvsroot/COMP/DBS/Servers/JavaServer/test/queries.txt
Revision: 1.8
Committed: Tue Jan 13 15:33:49 2009 UTC (16 years, 4 months ago) by valya
Content type: text/plain
Branch: MAIN
CVS Tags: DBS_2_1_6, DBS_2_1_5, DBS_2_1_4, DBS_2_1_3, DBS_2_1_2, DBS_2_1_1_patch2, DBS_2_1_1_patch1, DBS_2_1_1, DBS_2_1_1_pre3, DBS_2_1_1_pre2, DBS_2_1_1_pre1, DBS_2_1_0_patch_2, DBS_2_1_0_patch_1, DBS_2_1_0, DBS_2_1_0_pre2, DBS_2_1_0_pre1, DBS_2_0_9_patch_6, DBS_2_0_9_patch_5, DBS_2_0_9, DBS_2_0_9_pre11, DBS_2_0_9_pre10, DBS_2_0_9_pre9, DBS_2_0_9_pre8, DBS_2_0_9_patch_4, DBS_2_0_9_pre7, DBS_2_0_9_patch_3, DBS_2_0_9_pre6, DBS_2_0_9_patch_2, DBS_2_0_9_pre5, DBS_2_0_9_patch_1, DBS_2_0_9_pre4, DBS_2_0_9_pre3, DBS_2_0_9_pre2, DBS_2_0_9_pre1, DBS_2_0_8_patch_2, DBS_2_0_8_patch_1, DBS_2_0_8, DBS_2_0_8_pre7, DBS_2_0_8_pre6, DBS_2_0_8_pre5, DBS_2_0_8_pre4, DBS_2_0_8_pre3, DBS_2_0_8_pre2, DBS_2_0_8_pre1, DBS_2_0_7, DBS_2_0_7_pre7, deadlock_fix_attempt, DBS_2_0_7_pre6, DBS_2_0_7_pre5, DBS_2_0_7_pre4, DBS_2_0_7_pre3, DBS_2_0_7_pre1, DBS_2_0_6_patch_5, DBS_2_0_6_patch_4, DBS_2_0_6_patch_3, DBS_2_0_6_patch_2, DBS_2_0_6_patch1, DBS_2_0_6, DBS_2_0_6_pre8, DBS_2_0_6_pre7, DBS_2_0_6_pre6, DBS_2_0_6_pre5, DBS_2_0_6_pre4, DBS_2_0_6_pre3, DBS_2_0_6_pre2, DBS_2_0_6_pre1, HEAD
Branch point for: DBS_2_0_6_patch_51
Changes since 1.7: +1 -1 lines
Log Message: 
Added checksum attribute

File Contents

# Content
1 find file where file.release=CMSSW_1_7_1
2 find file,file.status,file.type, file.checksum where procds.release=CMSSW_1_7_1
3 find file.id,lumi.id where procds.release=CMSSW_1_7_1
4 find file.name, file.createdate where run.number=35672 and run.moddate>2
5 find file,file.size,dataset where procds.name=Online and file.size>546294916
6 find file, lumi where dataset = /CalPrivateGlobal-default/Online/RAW
7 find lumi where dataset=/CalPrivateGlobal-default/Online/RAW and procds.release=CMSSW_1_7_1
8 find count(file) where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM or run > 0
9 find file.release,file where dataset=/CalPrivateGlobal-default/Online/RAW and procds.release=CMSSW_1_7_1
10 find count(run) where run.number > 1 and run.number < 888800
11 find lumi.id,lumi.id,file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
12 find run where run.number>1 and run.number<100
13 find run.count where run.number > 1 and run.number < 100
14 find run.count where run > 1 and run < 100
15 find run.count where dataset=/CalPrivateGlobal-default/Online/RAW
16 find file,run,lumi where dataset=/GlobalMar08-Express/Online/RAW and file.type = STREAMER
17 find file, run,lumi where dataset like %Online%
18 find run,lumi where dataset like %Online%
19 find run,lumi,file where dataset like %Online%
20 find file.release where dataset=/CalPrivateGlobal-default/Online/RAW
21 find primds where primds.name like %test%
22 find dataset
23 find procds, procds.createdate
24 find primds
25 find procds.createby, run.modby
26 find file, procds.createby where file.modby like %sekhri% and dataset = /CalPrivateGlobal-default/Online/RAW
27 find file, procds.createby, file.modby, procds.createdate
28 find file where file.modby like %sekhri%
29 find procds.parent,procds.name,file,file.parent where procds.parent like %
30 find file where file.createby like %sekhri% or file.createby = abc
31 find file.parent,file where file.name = NEW_TEST0005
32 find lumi.id,file.id where dataset in (/CalPrivateGlobal-default/Online/RAW,/GlobalMar08-Express/Online/RAW)
33 find file,file.parent,run,dataset where file.parent like %NEW% or file.parent like %
34 find file.id,lumi.id,dataset where procds.release=CMSSW_1_7_1
35 find file.createby,file.modby,file.modby where file.createby like %sekhri% or file.modby like %sekhri% and file.createby like %sek%
36 find procds, procds.createdate,run,lumi.moddate where run.number in (1,2,3)
37 find run, run.numevents, run.numlss, run.totlumi, run.store, run.starttime, run.endtime
38 find dataset where site = T1_FR_CCIN2P3
39 find file where run > 1 and run < 1000000
40 find procds.status where dataset = /CalPrivateGlobal-default/Online/RAW
41 find procds, procds.era, procds.tag
42 find procds, procds.era, procds.tag where dataset = /CalPrivateGlobal-default/Online/RAW
43 find site
44 find run, run.createdate where run.createdate > 2008-05-01 12:05:12 order by run, run.createdate
45 find file.parent,file.parent, file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
46 find procds.parent,procds.name where procds.name like %Test% or procds.parent like %
47 find file.release where dataset=/CalPrivateGlobal-default/Online/RAW or dataset=/abc/Online/RAW
48 find file where dq = TIB_DCS=UNKNOWN&Tracker_Global=GOOD&TIB_Local=GOOD
49 find dataset, procds.createdate where dq = Tracker_Global=GOOD&TIB_Local=GOOD
50 find file,lumi,dataset where dq = Tracker_Global=GOOD&TIB_Local=GOOD&TIB_DCS=UNKNOWN or file.size > 1000
51 find file, file.tier
52 find file where file.tier = GEN
53 find run where release = test_Ver1_eaf67699-b539-487d-8713-07df617379db
54 find block , dataset where site = srm-disk.pic.es
55 find procds,file where procds.tier = GEN
56 find procds,file,file.tier where dataset like *
57 find file where site in ( srm-disk.pic.es, castorsrm.cr)
58 find procds,file where procds.tier in (GEN,SIM,RAW)
59 find ads,file
60 find release where file like *
61 find release where dataset like *
62 find release where dataset like * or file like *
63 find release where procds like * or file like *
64 find file.release where procds like * or file like *
65 find file,run,lumi where ads.name = MyAds
66 find lumi,ads
67 find ads, ads.type, ads.status, ads.createby
68 find file,lumi where ads.name = /TestPrimary_001_20080501_10h06m06s/TestProcessed_20080501_10h06m06s/GEN-SIM/TestAnalysisDSDef_005_20080501_10h06m06s
69 find ads, ads.dataset
70 find file,run,lumi where ads.name in ( MyAds, Myades )
71 find ads,file where dataset = /TestPrimary_001_20080501_10h06m06s/TestProcessed_20080501_10h06m06s/GEN-SIM
72 find ads, ads.def, file
73 find dataset.parent where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM and file.createdate > 0
74 find lumi.startevnum, lumi.endevnum, lumi.id where file.createdate > 0
75 find file where lumi.evnum = 150
76 find lumi, dataset where lumi.evnum = 150
77 find file, file.createdate where file.createdate = 2007-04-20
78 find file, file.createdate where file.createdate = 2007-04-20 11:27:21 CDT or file.moddate > 2008
79 find file, file.createdate where file.createdate = 2007-04-20 11:27:21
80 find run, run.createdate where run.createdate = 2008-05-01 12:05:12 order by run
81 find run, run.createdate where run.createdate = 2008-05-01 12:05
82 find run, run.createdate where run.createdate = 2008-05-01 12
83 find run, run.createdate where run.createdate = 2008-05-01
84 find run, run.createdate where run.createdate = 2008
85 find run, run.createdate where run.createdate < 2008
86 find run, run.createdate where run.createdate > 2008
87 find run,file order by file
88 find run,file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM order by file.createdate
89 find ilumi where run > 0
90 find ilumi where run > 0
91 find ilumi, file.name
92 find run where primds = test_primary_001
93 find count(file), dataset where dataset like *
94 find run, ilumi, file
95 find sum(file.size), dataset where file.size > 0
96 find file, dataset where release = test_Ver1_eaf67699-b539-487d-8713-07df617379db
97 find file where release = test_Ver1_eaf67699-b539-487d-8713-07df617379db
98 find dataset where release = test_Ver1_eaf67699-b539-487d-8713-07df617379db
99 find run, ilumi, file where run in (1,2,3)
100 find ilumi, file where run in (1,2,3)
101 find ilumi, file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
102 find ilumi, file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM order by file
103 find ilumi, dataset where run > 0
104 find ilumi
105 find block
106 find block, block.size, block.numfiles, block.numevents, block.status, block.createdate, block.moddate, block.createby, block.modby where dataset = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO
107 find block.size, block.numfiles, block.numevents, block.status, block.createdate, block.moddate, block.createby, block.modby where block = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO#01123fd3-5486-41fe-8b90-7dbb8fbe69b8
108 find block.count where dataset = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO
109 find count(block) where dataset = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO
110 find run.count where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
111 find lumi, lumi.starttime, lumi.endtime
112 find dataset.id, dataset.status, dataset.era, dataset.tag, dataset.createdate, dataset.moddate, dataset.createby, dataset.modby where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
113 find dataset.release, dataset.era, dataset.tag, dataset.status, dataset.createdate, dataset.moddate, dataset.createby, dataset.modby where dataset = /CSA07Muon/Skim-zToTauTau_MuTau-Tier0-A1-Chowder/USER
114 find file.child, file where file = NEW_TEST0002
115 find file where file.child = NEW_TEST0005
116 find sum(file.size) where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM and file.size > 0
117 find sum(run.numevents) where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM and file.size > 0
118 find sum(block.size) where dataset = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO
119 find phygrp
120 find phygrp where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
121 find dataset where phygrp like *BPositive
122 find dataset where phygrp in (BPositive,Any )
123 find file where phygrp in (BPositive,Any )
124 find file,run where phygrp in (BPositive,Any )
125 find phygrp.id, phygrp.name
126 find phygrp, phygrp.id, phygrp.createdate , phygrp.moddate, phygrp.createby, phygrp.modby
127 find dataset where pset = associatorL25PixelTauIsolated.coneSize>0&associatorL25SingleTau.coneSize>0&associatorL25SingleTau.jets<>a
128 find file, lumi where pset = associatorL25PixelTauIsolated.coneSize>0
129 find dataset where site = T1_FR_CCIN2P3
130 find dataset where site in ( T1_FR_CCIN2P3, T1_TW_ASGC)
131 find dataset where site like *A*
132 find dataset where site like castorsrm.cr.cnaf*
133 find dataset where site = castorsrm.cr.cnaf.infn.it
134 find dataset where site = test_seM_ee563854-0ed2-4010-82ba-e94e7868cbff
135 find dataset, site
136 find site
137 find dataset where run between 51437 and 51450 or run between 0 and 30000
138 find dataset where dataset.id between 1 and 2 or dataset like *on*
139 find algo.id, algo.family, algo.exe,algo.hash, algo.content where dataset like *on*
140 find dataset where algo.exe = *CMS* or algo.family=*C*
141 find file where algo.exe = *CMS* or algo.family=*C*
142 find algo, algo.createby, algo.modby, algo.moddate where dataset like *on*
143 find datatype
144 find dataset where datatype = cosmic
145 find file where datatype = cosmic
146 find datatype where dataset = *on*
147 find datatype, datatype.id, datatype.createdate, datatype.moddate, datatype.createby, datatype.modby where dataset = *on*
148 find dataset where site != caf.cern.ch
149 find dataset where site = caf.cern.ch
150 find dataset where site = T1_CH_CERN
151 find dataset where site != T1_CH_CERN
152 find dataset where site in (T1_CH_CERN , T0_CH_CERN)
153 find procds.xsection where procds like *
154 find dataset.xsection where dataset like *
155 find algo.version, algo.family, algo.exe where algo.family like *
156 find config, config.name, config.type, config.version, config.content, config.hash, config.id, config.createdate, config.createby, config.moddate, config.modby
157 find mcdesc, mcdesc.name, mcdesc.def, mcdesc.parent, mcdesc.createdate, mcdesc.createby where primds like *
158 find trigdesc, trigdesc.name, trigdesc.createdate, trigdesc.createby where primds like *
159 find primds order by datatype
160 find primds where primds like * order by datatype
161 find primds where primds like * order by datatype desc