General Ledger Code Combinations

I need to perform an exercise to close a number of unused general ledger code combinations.

To identify those that need closing I'd like to run a script that will telll me, for each code combination:

1. The full code combination

2. The functional balance of that code combination for the current period

3. The last time the code combinaiton was used (via journal) to update the balance - ie the sys date of a journal that was used to post an entry to that code

4. The period name of when the last update occurred.

Can anyone help with a report or sql script?