Grouper Users - Open Discussion List

["Black, Carey M." <>]

All,

I have started to think about how I want to create some "standard reports" 
from grouper.
        Stems/groups created yesterday, this week, this month, etc...
        Counts of:
                Memberships in *special* groups in a Stem.
        Events processed by Change Log Consumers (and watching for them 
"getting stuck") or other daemon jobs.
        Change Log Consumers that have not processed entries in so long that 
they have "missed some" ( end of life conditions for CLC's )
        Etc...


        I am leaning toward using GSH scripts.
                It would let me have to access the Grouper API.
                But there are also things in the RDBMS that I want to poke at 
too.

It would be useful if I could do "generic SQL" statements and parse the 
results in a GSH script.

I have figured out how to get a single String result:
        aStringReturned = HibernateSession.bySqlStatic().select(String.class, 
"select count(*) from grouper_change_log_consumer");



But want I want to be able to do is sql like:
        "select * from grouper_change_log_consumer"

And then walk the results looking at each row and the column values.


This just has to be possible. I just am not seeing a good example of how to 
start.
        Is there something in the existing code that I could model off of?
        Has anyone done this kind of thing before?

-- 
Carey Matthew