Details
-
New Feature
-
Resolution: Fixed
-
Minor
-
None
-
None
Description
Penn currently has 11,685,969 records in grouper_audit_entry_v
addGroupMemberhip and deleteGroupMembership has 80% of the entries
99% of entries have no logged_in_subject_id
99% are loader, blank, grouperShell
30% are blank user id
70k are from the UI less than 1%
we could delete any record over 5 years if people want (we have 90k records older than 5 years which are grouperUI or grouperWS)
select count(1) from grouper_audit_entry_v;
|
|
|
select GAEV.ACTION_NAME, count(*) from grouper_audit_entry_v gaev group by gaev.action_name;
|
|
|
select GAEV.LOGGED_IN_SUBJECT_ID, count(*) from grouper_audit_entry_v gaev group by GAEV.LOGGED_IN_SUBJECT_ID;
|
|
|
select GAEV.GROUPER_ENGINE , count(*) from grouper_audit_entry_v gaev group by GAEV.GROUPER_ENGINE;
|
|
|
select count(*) from grouper_audit_entry_v gaev where GAEV.ACT_AS_MEMBER_ID is null and GAEV.LOGGED_IN_MEMBER_ID is null;
|
|
|
select count(*) from grouper_audit_entry_v gaev where GAEV.GROUPER_ENGINE = 'grouperUI';
|
|
|
select count(*) from grouper_audit_entry_v gaev where GAEV.GROUPER_ENGINE in ('grouperUI', 'grouperWS') and GAEV.CREATED_ON < 1357016400000;
|