Versions Compared

Old Version 1

changes.mady.by.user Chris Hyzer (upenn.edu)

Saved on

compared with

New Version 2

changes.mady.by.user Chris Hyzer (upenn.edu)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This query (change the millis to be a specific date) finds users since 4/22/2019 with more than two audit records

this is penn specific, you can tweak it

Code Block
select distinct logged_inGV.LOGGED_IN_subject_id ID , count(*) as the_count 
from grouper_audit_entry_v gv where created_on > 1555905600000 
and gv.logged_in_subject_id is not null and logged_in_source_id = 'pennperson'
group by LOGGED_IN_subject_ID having count(*) > 2;