Question
TechMahindra
TechMahindra
IN
TechMahindra
Posted: Dec 31, 2024
Last activity: Jan 1, 2025
Last activity: 1 Jan 2025 11:18 EST
Closed
OOTB database table
Which OOTB database table in Pega captures the details of User ID, login time and logout time with date?
Posted: 1 year ago
HCA Healthcare
HCA Healthcare
US
Posted: 1 year ago
Tata Consultancy Services
Tata Consultancy Services
IN
Hi @Sairohith
I am curious about the OOTB table, as you mentioned pr_logins. I don't see this table in Personal Edition 8.6, Community Edition, or Enterprise Edition 8.4.6 too.
May I know which version you are using and the type of edition?
Thanks,
Ashok
Posted: 1 year ago
Accenture
Accenture
IN
Hi @SANTHARAMN17023936, pega stores the operator login related info's under pr_operators table under PegaDATA.
I hope the link helps - https://support.pega.com/question/how-customize-storage-login-user-details
@SANTHARAMN17023936 The OOTB
pr_loginstable in Pega stores details about user sessions, including the User ID, login time, and logout time. The key columns are pxUserID for the user's ID, pxCreateDateTime for login time, and pxSessionEndDateTime for logout time. You can query this table to track user activity, such as when they logged in and out, by filtering with the User ID or session details. For example, you can use a query to retrieve these details and order them by login time to view the latest activity. This table is part of Pega’s built-in logging system for monitoring user sessions