I am looking for a SQL script to find the user who is responsible for the current step in any CR

We had a Developer who figured this out but who has since left.  He had this working to show all CRs in his area and who submitted them and who is responsible for the current step in each.

I am looking to recreate this in a SQL portlet, but am struggling to find the right tables/fields.

Anyone already doing this who could lend a hand?

thanks!!

Tags: