How many password reset we did globally

[Theodor]

Hello,

I have a requirement to find how many password reset we performed globally in our instance over 1 year. 
Is there any way this can be done?

Thank you so much,

Teodor

[Community Alums]

Hi @Theodor ,

You can report on "pwd_reset_activity" table to get the details as per your requirement, also if you want to know specific details then, check the below tables :

Table name	Description
Password Reset Active Answer [pwd_active_answer]	Security questions and associated answers, in an encrypted state, that users selected while going through the enrollment process.
Password Reset Active Question [pwd_active_question]	Security questions that users selected while going through the enrollment process.
Password Reset Activity Log [pwd_reset_activity]	All Password Reset requests.
Password Reset Activity Monitor [pwd_activity_monitor]	Password Reset lockout activity.
Password Reset Credential Store [pwd_cred_store]	Password Reset credential stores that are available.
Password Reset Credential Store Parameters [pwd_cred_store_param]	User-created credential store parameters.
Password Reset Credential Store Types [pwd_cred_store_type]	Password Reset credential store types that are available.
Password Reset Desktop Access Control [pwd_access_control]	Password Reset Windows Application access control.
Password Reset Desktop Access Log [pwd_access_log]	Password Reset Windows Application access logs.
Password Reset Device Enrollment Code [pwd_dvc_enrollment_code]	Device enrollment codes that were sent to users during SMS code enrollment.
Password Reset Devices [pwd_device]	User SMS devices that are in a state of verified.
Password Reset Email Verification Code [pwd_email_code]	Verification codes that were sent to users via email for password reset or email address enrollment.
Password Reset Enrollment for Verification [pwd_enrollment]	Information about user enrollment by verification.
Password Reset Enrollment Snapshot [pwd_enrollment_snapshot]	Snapshot of user enrollment by verification. This table is used for the reporting purpose. The Sync Password Reset Enrollment Snapshot Data Monthly scheduled job runs once a month to generate or sync snapshot data in this table. The data, such as sys_user creation or deletion, verification to process creation or deletion, and so on, is synchronized. Password Reset DB listener is used to create or update the data in this table which is managed by the pwd_reset.enable.dbListener property with default value as true. If you’re an admin and want to manually sync the data in this table related to an active process, select Sync Enrollment Snapshot Data on that Password Reset process. You can turn off the data synchronization in this table through the DB listener or the monthly scheduled job by setting the pwd_reset.enable.enrollment_snapshot property to false. Note: Initially, an inactive record is created by the DB listener for a user-verification pair. When the users enrol themselves on the Password Reset Enrolment page, the record becomes active in this table.
Password Reset Extension Type [pwd_extension_type]	Extension types that are available.
Password Reset History [pwd_history]	History of passwords that users reset.
Password Reset Identification Type [pwd_identification_type]	Password Reset identification types that are available.
Password Reset Process [pwd_process]	Password Reset processes that are available.
Password Reset Process Credential Store [pwd_map_proc_to_cred_store]	Credential stores and the associated Password Reset processes that the application is using.
Password Reset Process User Group [pwd_map_proc_to_group]	Groups and the associated Password Reset processes that the application is using.
Password Reset Process Verification [pwd_map_proc_to_verification]	Verifications and the associated Password Reset processes that the application is using.
Password Reset Question [pwd_question]	Questions that the application uses for security question verifications.
Password Reset Request [pwd_reset_request]	Information about Password Reset requests.
Password Reset Request Verification [pwd_map_request_to_verification]	Password reset requests and the associated verification that the application is using.
Password Reset SMS Verification Code [pwd_sms_code]	SMS verification codes that were sent to users for a password reset.
Password Reset User Lockout [pwd_user_lockout]	Users that are locked out of Password Reset.
Password Reset Verification [pwd_verification]	Verifications that are available.
Password Reset Verification Param [pwd_verification_param]	User-created verification parameters.
Password Reset Verification Type [pwd_verification_type]	Password Reset verification types that are available.

[Theodor]

Hi @Community Alums.

It would have worked perfectly but that table stores logs only for the last 3 months and I need for last year.

I guess there is no other option for that, no ?

Thank you,

Teodor

[Amit Pandey]

Hi @Theodor 

As per Table Rotation, most of the logs get flushed out after three months. Therefore, I don't think you can get this date beyond three months.

Regards,
Amit

[Mark Manders]

OOB audit isn't activated on the user table, but if you have it active, you could look into the sys_history_line or audit table to see the number of changes there (not sure how long that is kept, but I believe it's longer than 3 months)