> Maybe the report could be html-ized and perhaps
named by date for optional placement in a web server's directory ?
That’s a good idea. I added a property to the
grouper-loader.properties file:
#if you put a directory here, the daily reports will
be saved there, and you can
#link up to a web service or store them or
whatever. e.g. /home/grouper/reports/
daily.report.saveInDirectory =
So you can put a dir in there, and it will save each report as a
text file. I think the text files will display ok if served by a web
server which sets the content type correctly. Maybe in 1.5 or greater we
can switch to HTML if we like. Incidentally, if the UI is run on the same
server as loader, we could have a link between some protected admin section of
the UI and the loader report history…
So now you can do either email, or file saves, or both with the
report…
Regards,
Chris
From:
[mailto:] On Behalf Of Tom Zeller
Sent: Thursday, December 11, 2008 11:28 AM
To: Chris Hyzer
Cc: Grouper Users Mailing List
Subject: Re: [grouper-users] FW: Grouper report
Chris,
Maybe the report could be html-ized and perhaps named by
date for optional placement in a web server's directory ?
TomZ
On Thu, Dec 11, 2008 at 9:36 AM, Chris Hyzer <> wrote:
This is what the new grouper
daily report looks like. If you have it enabled, and are running the
loader, you will get a daily status email about your grouper instance.
Let me know any feedback asap if we want to tweak the 1.4 format.
Regards,
Chris
Ps. Note: this is sanitized... :)
Pps. Also note, the processing time aggregate I think is not correct...
> -----Original Message-----
> From:
> [mailto:]
> Sent: Thursday, December 11, 2008 7:38 AM
> To: Chris Hyzer
> Subject: Grouper report
>
> Grouper daily report
>
> ----------------
> OVERALL:
> ----------------
> environment: PROD
> memberships: 135,224
> groups: 19
> members: 56,041
> folders: 14
> unresolvable subjects: 1,072
> bad memberships: 0
>
> ----------------
> WITHIN LAST DAY:
> ----------------
> new memberships: 1,060
> new groups: 0
> updated groups: 0
> new folders: 0
>
> ----------------
> LOADER SUMMARY WITHIN LAST DAY
> ----------------
> jobs: 17
> successes: 13
> errors: 3
> unresolvable subjects: 0
> inserts: 0
> updates: 0
> deletes: 0
> processing time: 2,202,050ms
>
> ----------------
> LOADER JOBS NON-ERROR
> ----------------
>
> job:
> SQL_SIMPLE__penn:community:employeeNonTemp__0970551c-b2f3-4b84-955d-
> 23529fd35bf1 (17798 total count)
> status: SUCCESS, started:
2008-12-10 10:38:00.0 (58536ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
SQL_SIMPLE__penn:community:employee__34ebb988-ce8b-
> 4faa-94d9-b4760baaba1b (28938 total count)
> status: SUCCESS, started:
2008-12-10 10:46:00.0 (109586ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
> SQL_GROUP_LIST__penn:community:employee:orgGroups__6f75f636-ad7c-4d50-
> a02f-c779b94c4aa8 (125 total count)
> status: SUCCESS, started:
2008-12-10 09:08:00.0 (1793ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
> subjobFor_penn:community:employee:orgs:employeeOrg9142 (80 total count)
> status: SUCCESS, started:
2008-12-10 09:08:01.0 (0ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
> subjobFor_penn:community:employee:orgs:employeeOrg9143 (27 total count)
> status: SUCCESS, started:
2008-12-10 09:08:02.0 (0ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
> subjobFor_penn:community:employee:orgs:employeeOrg9147 (18 total count)
> status: SUCCESS, started:
2008-12-10 09:08:02.0 (0ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
> SQL_SIMPLE__penn:community:employeeNonTemp__0970551c-b2f3-4b84-955d-
> 23529fd35bf1 (17807 total count)
> status: SUCCESS, started:
2008-12-11 05:38:00.0 (59376ms)
> inserts/updates/deletes: 11/02
> unresolvable subjects: 0
>
> job:
SQL_SIMPLE__penn:community:employee__34ebb988-ce8b-
> 4faa-94d9-b4760baaba1b (28949 total count)
> status: SUCCESS, started:
2008-12-11 05:46:00.0 (102183ms)
> inserts/updates/deletes: 22/011
> unresolvable subjects: 0
>
> job:
SQL_SIMPLE__penn:community:faculty__6b50e7c3-a468-
> 4373-b810-e1f259304f9e (8119 total count)
> status: SUCCESS, started:
2008-12-10 10:18:00.0 (27262ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
SQL_SIMPLE__penn:community:faculty__6b50e7c3-a468-
> 4373-b810-e1f259304f9e (8119 total count)
> status: SUCCESS, started:
2008-12-10 14:18:00.0 (26029ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
SQL_SIMPLE__penn:community:faculty__6b50e7c3-a468-
> 4373-b810-e1f259304f9e (8123 total count)
> status: SUCCESS, started:
2008-12-11 05:18:01.0 (34243ms)
> inserts/updates/deletes: 5/01
> unresolvable subjects: 0
>
> job:
MAINTENANCE_cleanLogs (0 total count)
> status: SUCCESS, started:
2008-12-11 06:00:00.0 (121ms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> job:
> SQL_SIMPLE__penn:community:facultyStudentStaff__ba018af2-4774-47fd-
> b831-cce3effe0e74 (54008 total count)
> status: SUCCESS, started:
2008-12-11 05:29:00.0 (393283ms)
> inserts/updates/deletes: 1006/0563
> unresolvable subjects: 0
>
> job:
MAINTENANCE_grouperReport (0 total count)
> status: STARTED, started:
2008-12-11 07:00:00.0 (nullms)
> inserts/updates/deletes: 0/00
> unresolvable subjects: 0
>
> ----------------
> LOADER JOBS WITH ERROR
> ----------------
>
> job:
> SQL_SIMPLE__penn:community:facultyStudentStaff__ba018af2-4774-47fd-
> b831-cce3effe0e74(53997 total count)
> status: ERROR, started:
2008-12-10 10:29:00.0 (54239ms)
> inserts/updates/deletes: 0/0/0
> unresolvable subjects: 0
> error: null
>
> job:
> SQL_SIMPLE__penn:community:facultyStudentStaff__ba018af2-4774-47fd-
> b831-cce3effe0e74(53997 total count)
> status: ERROR, started:
2008-12-10 14:29:00.0 (125313ms)
> inserts/updates/deletes: 0/0/0
> unresolvable subjects: 0
> error: null
>
> job:
MAINTENANCE_grouperReport(0 total count)
> status: ERROR, started:
2008-12-10 07:00:00.0 (1210086ms)
> inserts/updates/deletes: 0/0/0
> unresolvable subjects: 0
> error: null
>
> ----------------
> UNRESOLVABLE SUBJECTS 50 of 1072
> ----------------
> g:gsa: 2dc973dd-5bbb-448f-957b-e0b80bb1d80d
> pennperson: 11111110
> pennperson: 11111111
> pennperson: 11111112
> pennperson: 11111113
> pennperson: 11111114
> pennperson: 11111115
> pennperson: 11111116
> pennperson: 11111117
> pennperson: 11111118
> pennperson: 11111119
> pennperson: 11111110
> pennperson: 11111111
> pennperson: 11111112
> pennperson: 11111113
> pennperson: 11111114
> pennperson: 11111115
> pennperson: 11111116
> pennperson: 11111117
> pennperson: 11111118
> pennperson: 11111119
> pennperson: 11111110
> pennperson: 11111111
> pennperson: 11111112
> pennperson: 11111113
> pennperson: 11111114
> pennperson: 11111115
> pennperson: 11111116
> pennperson: 11111117
> pennperson: 11111118
> pennperson: 11111119
> pennperson: 11111110
> pennperson: 11111111
> pennperson: 11111112
> pennperson: 11111113
> pennperson: 11111114
> pennperson: 11111115
> pennperson: 11111116
> pennperson: 11111117
> pennperson: 11111118
> pennperson: 11111119
> pennperson: 11111110
> pennperson: 11111111
> pennperson: 11111112
> pennperson: 11111113
> pennperson: 11111114
> pennperson: 11111115
> pennperson: 11111116
> pennperson: 11111117
> pennperson: 11111118
> pennperson: 11111119
> g:gsa: 737c6959-5761-4fef-86d7-15513de885e5
> servPrinc: penn_groups/something.edu
>
> ----------------
> GROUPER INFO
> ----------------
> version: 1.4.0-rc2, build date: 2008/12/11 00:48:49, env: PROD
> os.name: Linux
> os.arch: i386
> os.version: 2.6.18-53.1.13.el5PAE
> java.version: 1.6.0_02
> java.vendor: Sun Microsystems Inc.
> java.class.path:
> :/opt/appserv/tomcat6base/bin/bootstrap.jar:/opt/appserv/tomcat6base/bi
> n/commons-logging-api.jar
> heapSize: 197 MB
> heapMaxSize: 197 MB
> heapSizeFree: 45 MB
>
> privileges.access.interface:
> edu.internet2.middleware.grouper.GrouperAccessAdapter
> privileges.naming.interface:
> edu.internet2.middleware.grouper.GrouperNamingAdapter
> privileges.access.cache.interface:
> privileges.naming.cache.interface:
> groups.wheel.use: true
> groups.wheel.group: penn:etc:sysAdminGroup
>
> source: id=servPrinc name=Kerberos service principals
> class=JDBCSourceAdapter
> source: id=g:gsa name=Grouper: Group Source Adapter
> class=GrouperSourceAdapter
> source: id=pennperson name=Penn person class=JDBCSourceAdapter
> source: id=g:isa name=Grouper: Internal Source Adapter
> class=InternalSourceAdapter
>
> hibernate.dialect: org.hibernate.dialect.Oracle10gDialect
> hibernate.connection.driver_class: oracle.jdbc.driver.OracleDriver
> hibernate.cache.provider_class: org.hibernate.cache.EhCacheProvider
|