How can I get the commit hash from a Jira ticket with the Jira/bitbucket integration?

[Dan Meador]

I'm trying to collect ALL commits from just my bug tickets in order to see which files were altered to fix issues. I'm trying to just get the commit hashes and that would be enough to create a script to run through and grab the info I need.

Any idea how I would do this?

[Muhammad Ramzan(Atlassian Certified Master)]

you can easily get from database 

bb_pr_commit table contains all the commit hash

sta_pull_request table contains all from_hash and to_hast (pull requests with commits)