~/l/test: bash
bash-3.00$ source /uscmst1/prod/sw/cms/DBS/Clients/Python/setup.sh

bash-3.00$ dbs search --query="find file, file.release, file.size, file.type, file.tier, file.status, file.createdate, file.moddate, file.modby where file = /store/mc/CSA08/MuonPT11/GEN-SIM-RECO/CSA08_S156_v1/0005/0248F081-E22C-DD11-ADCA-0030487E4EC7.root"

bash-3.00$ dbs search --query="find site where file=/store/mc/CSA08/MuonPT11/GEN-SIM-RECO/CSA08_S156_v1/0005/0248F081-E22C-DD11-ADCA-0030487E4EC7.root"

dbs search --query="find file where site=cmssrm.fnal.gov file like /store/mc/CSA08/"

and from any set up (with cmsenv) workarea one can check for PFN using:

EdmFileUtil -d /store/mc/CSA08/JetET30/GEN-SIM-RECO/CSA08_S156_v1/0002/000250F6-A72B-DD11-8904-00145E1D6204.root