Project

General

Profile

DB Query

How to query the PUBS DB to identify run.subrun files with a specific status for a given project (i.e. DB table).

log into smc:

ssh -Y uboonepro@ubdaq-prod-smc

Log into DB:
psql -d procdb -U uboonepro 

type in the password, and then you can issue that command. Ask PUBS expert if you need to identify the password. Only PUBS experts can follow these instructions.
Then, enter queries such as this one:
 select * from prod_transfer_binary_near12dropbox_near1 where status != 1 and status!=1006 and status!=1002;

Where you need to specify the table name you are interested (here it is prod_transfer_near12dropbox_near1).