Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-1674

add daemon to trim auditing table

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.1, 2.4.0, 2.3.0.patch
    • Component/s: grouperLoader
    • Labels:
      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;
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
                Reporter:
                chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: