In a patch in Grouper 2.4, Grouper will be able to have reports. This will start simple and we can add more features
High level description
- Configure a report on a group or folder
- This report will have a cron that will run like loader jobs run
- Reports consist of a SQL to run in a database, generating a CSV file
- The output of the report will be encrypted and stored to storage
- Users can be notified by email that the report exists
- When the login they can download the most recent report
- This will have Grouper reverse proxy the report from storage, unencrypt it, and deliver it to the user
- Reports will be automatically deleted after 30 days
Configuration
The configuration will follow the same attribute structure as other Grouper modules like attestation and deprovisioning
To Do later
- Configure how long reports are stored
- Centralized report dashboard
- Have a config option to "run now" (allows report viewers to run now)
- This would send a message to a daemon to run so it doesnt run in the UI
- Like Loader "run now"
- Allow another report type which runs off membership list (not straight SQL)
- Allow non admins to configure?
- Allow more columns to be added (join other database tables if allowed)
- Add another output type for JASPER report (PDF, etc)
- Support excel
- Support more storage options, e.g. database with blobs
- Allow fields to be added from an LDAP filter