PSACCESSLOG - huge number of records for a single user in one day
we see 10000 of login records in the PSACCESSLOG table, mostly with PT_SIGNON_TYPE = 0 , we can't replicate the same scenario again, anyone have seen these kinds of records, any advise?.
select distinct OPRID, count(distinct(OPRID)) from PSACCESSLOG where LOGINDTTM >= getdate() -1;