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).