OOTB database table

General
, , , ,
1

Which OOTB database table in Pega captures the details of User ID, login time and logout time with date?

2

@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

3

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

4

Hi @SANTHARAMN17023936, pega stores the operator login related info’s under pr_operators table under PegaDATA.

I hope the link helps - How to customize storage of login user details | Support Center