Grouper Users - Open Discussion List

["Redman, Chad" <>]

We did exactly that! We have a custom class we can call from the command 
line, and schedule it to run daily.

It reports the following queries:

* Summary of jobs per day, job type, host, and status; totals or averages for 
the numeric fields to spot trends
* Last 50 memberships added (Date Added, Group, Member, Creator)
* Last 15 groups created (Date Added, Group, Creator)
* Last 10 stems created (Date Added, Stem, Creator)
* Optional usdu results
* System info and object counts:
  - environment
  - memberships
  - groups
  - members
  - folders


The last 50 memberships added currently includes indirect memberships which 
is less useful. At some point we will change this to direct memberships.

These are the command line options:

usage: edu.unc.its.idm.grouper.sync.SyncRunner
 -d,--delete <arg>   After reporting, delete the report rows from the
                     loader log table from this many days ago
 -e,--end <arg>      Number of days ago for report end
 -h,--help           Print this message
 -s,--start <arg>    Number of days ago for report start
 -u,--usdu           Report on invalid subject IDs

We run with options: --start 7 --end 0 --delete 90 --usdu

The usdu is probably overkill; it makes the job go from 2 minutes to 25 
minutes.

The output is straight text, so we pipe it directly to mail to the IDM group.

I can send you the source or post here if interested.

-Chad




-----Original Message-----
From:  
[] On Behalf Of Black, Carey M.
Sent: Tuesday, April 09, 2019 10:17 AM
To: 
Subject: [grouper-users] Grouper daily report... leaves me with questions....

Does anyone use the Grouper daily report?

Every day I see things like this:

"
----------------
WITHIN LAST DAY:
----------------
new memberships:       2,502
new groups:            70
updated groups:        4
new folders:           27
"

And I am left wondering...
        Which users were added to which groups on day "x"?
        What are the new groups created on day "x"?
        What groups were updated on day "x"? ( And what was updated about 
them? )
        What are the new Folders created on day "x"?
        What memberships were added to existing groups on day "x"?

Has anyone worked out some SQL (or GSH scripts :) ) to dig around in the 
DB/API and produce more detailed daily reports?

Same questions apply for the "LOADER SUMMARY WITHIN LAST DAY" and "LOADER 
JOBS" sections too...

Maybe the upcoming "Reports" feature will provide a UI interface to run the 
SQL reports, but the SQL is still needed. :)

-- 
Carey Matthew