How to check the contents of the offline databases

The easiest possibility is to use the web interface on https://cmsweb.cern.ch/conddb/ :

1. In the Service field, set the database you want to check.
2. In the Schema field, set the account name you want to use (for valid account names, see HcalOfflineDatabaseContents).
3. The Via Cache checkbox determines if you check the database directly (unset) or via frontier cache (set).
4. Click on the List all tags button. A list of available tags for the given database and account appear.
5. Mark the tag you are interested in in the list of tags and click the Display IOV for selected tags button, and you will get a list of IOVs at the bottom of the page that are available for this tag.

Another possibility to check the tags that are in the offline databases (especially if the web interface is broken or not updated with the latest account names) is to use command-line tools. For this, you need a recent CMSSW release. Inside the release, after the usual eval `scramv1 r -csh`, you use the following commands:

• cmscond_list_iov -c format://DBname/DBaccount -a , to get a list of available tags from the database DBname and account DBaccount,
• cmscond_list_iov -c format://DBname/DBaccount -t DBtag , to inspect the IOVs of the tag DBtag.

• frontier://cmsfrontier.cern.ch:8000/FrontierDev , ORCOFF development DB
• frontier://cmsfrontier.cern.ch:8000/FrontierInt , ORCOFF integration DB
• frontier://cmsfrontier.cern.ch:8000/Frontier , ORCOFF production DB
• frontier://cmsfrontier.cern.ch:8000/FrontierOn , ORCON_PROD

The account name, DBaccount, is identical as the one used in the web interface. You can also check on the HcalOfflineDatabaseContents Twiki page.

-- RadekOfierzynski - 29 Jan 2008