I need SQL query for getting the full user name of a specific person who is responsible for a bug.
EX. if I specified BG_RESPONSIBLE as 'johnd', I need to get John Doe.
you can't get it from the project database. You need to query qcsiteadmin_db.users
... just another Tester ...