Where can I find the IDs/Keys in the database for Scriptrunner objects?

[Corey Leighton]

I am trying to build a way to give some advanced metrics for the scriptrunner objects we use (scripted fields, listeners, etc) based on the information scriptrunner stores in the database.  I see some data in the database tables, including the runtime stats, but I can't find some critical details.  In the run result table, the key is obviously for each of the objects, but I can't find where that key maps to an object.  In particular, I can't find where the behaviors, listeners and scripted field keys are stored.  I only see fragments, jobs and resources in one of the other AO tables.

[PD Sheehan]

From the documentation

import com.onresolve.scriptrunner.db.DatabaseUtil 
DatabaseUtil.withSql('local') { sql -> 
   sql.rows('select * from project') 
}