Who is this article for?

Users wanting to find or report on the date users were created.

No elevated permissions are required.

This article provides guidance on generating reports detailing when users were given access to Please Review.

1. Native Database Authentication Users

Please Review does not currently store user creation dates as of version v7.8, making it impossible to generate these reports. Reporting on users' last login dates is possible through PleaseReport, but not creation dates. A feature request (Dev reference PR-31249) aims to include user creation date tracking in v7.9. This feature will apply only to users added after its implementation.

2. Duplicate Users

Users must have unique email addresses, but if you have duplicate users with different emails, you can determine which was created first by using their ObjectId in the T_Subject table. The user with the lowest ID is the oldest.

Alternatively, without accessing the database, you can edit the user within the system, such as workgroup memberships or usernames. If multiple login sources exist, you might see **subjectid=** in the address bar, which will help you identify the user in question.

3. Other Login Sources

For users utilizing external login sources, you can potentially audit when they joined Please Review by reviewing the external system’s auditing features.

4. Other User Updates

Users can perform various updates within the system. Here’s what can and can't be reported:

• Last time each user updated a review: Can be reported using the PleaseReport module based on the participant table update date.
• Who added/edited user details: Not retained. If using external authentication, some values may be locked to the external source and could be reported there.
• Who added/edited a workgroup: Not retained. If using locked workgroups with imported roles, this may be reportable externally.
• Who amended configuration settings and when: This depends on your operating system. Some settings can be configured using Runtime\bin\AdminClient.exe, but no record is kept of who made changes or when.
• Transferring ownership of a review: Not retained.
• Who added/edited admin settings: Not retained.
• Licenses left: Included in license reports and emails when 10% or 0% of a role is left. Custom reporting on licenses may require developer input and may be chargeable.