Question
TechMahindra
IN
Last activity: 1 Jan 2025 11:18 EST
OOTB database table
Which OOTB database table in Pega captures the details of User ID, login time and logout time with date?
HCA Healthcare
US
@SANTHARAMN17023936 The OOTB pr_logins table 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
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
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