...
- Look for reports that have more than 100 instances, and delete the older ones (reports and metadata)
- Look for reports older than 30 days and delete (reports and metadata)
FAQ
- As a grouper admin, how do I get the correct SQL?
- We will publish a lot of examples and increase the number of views Grouper has
- Can I join to external person tables to get extra attributes
- Absolutely, if you can ETL the data to your grouper database or maybe join over DB link then you will have extra attributes. If people need LDAP attributes we can discuss that
- Note: columns in the report could also be group memberships (e.g. enrolled in MFA? enrolled in Duo push? required to be in MFA? etc)
To Do later
- Errors in report should be logged and throw error but maybe also store error in txt report (not sent out or available except to admins)
- Add diagnostics to test that a report is setup correctly
- Add paging to report instance list
- Configure how long reports are stored
- Screen in a user's subject screen that shows all the reports they have access to
- 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
- Add ability to display a CSV in the JSP in an HTML table
- Add metadata to make it clickable?
- Support more storage options, e.g. database with blobs (needs to wait until 2.5)
- Allow fields to be added from an LDAP filter
- Add the daily Grouper report to run like this (dont email)