Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] Grouper daily report... leaves me with questions....

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] Grouper daily report... leaves me with questions....

Chronological Thread 
  • From: "Redman, Chad" <>
  • To: "Black, Carey M." <>, "" <>
  • Subject: RE: [grouper-users] Grouper daily report... leaves me with questions....
  • Date: Tue, 9 Apr 2019 16:24:44 +0000

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

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.


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

Does anyone use the Grouper daily report?

Every day I see things like this:

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

Archive powered by MHonArc 2.6.19.

Top of Page