With ICE v. >= 3.1.42-0, you can examine the content of ICE's database using the queryDb tool:

Pathname: /opt/glite/bin/queryDb

USAGE: queryDb --conf|-c <WMS CONFIGURATION FILE> [options]

options: 
  --verbose|-v          Verbose output (print each db's record)
  --status-filter|-s    Select only records in which the status column is one
                        of those specified as option argument; more states can
                        be ',' separated and they must be:
                        REGISTERED
                        PENDING
                        IDLE
                        RUNNING
                        REALLY_RUNNING
                        CANCELLED
                        HELD
                        ABORTED
                        DONE_OK
                        DONE_FAILED
                        UNKNOWN
                        PURGED

  --userdn|-u           Print the USERDN column of the job table
  --creamjobid|-C       Print the CREAM JOB ID column of the job table
  --gridjobid|-G        Print the GRID JOB ID column of the job table
  --userproxy|-p        Print the USER PROXY column of the job table
  --cream-url|-r        Print the CREAM URL column of the job table
  --myproxy-url|-m      Print the MYPROXY URL column of the job table
  --status|-S           Print the STATUS column of the job table
  --lease-id|-L         Print the LEASE-ID column of the job table
  --delegation-id|-D    Print the DELEGATION-ID column of the job table
  --worker-node|-w      Print the WORKER-NODE column of the job table
  --help|-h             Print this help

Note: using -u/-C/etc. switches is useless if -v is not specified (without -v no record will be printed)