The DBC.DBase table stores the date and time a password was last changed by a user.
Query the DBC.UsersV view, which references the DBC.DBase table and other system tables, selecting the columns PasswordLastModDate and PasswordLastModTime, to see the latest activities against passwords, for example:
SELECT UserName, PasswordLastModDate, PasswordLastModTime FROM DBC.Users;
Result:
*** Query completed. 6 total rows found. 3 columns returned. *** Total elapsed time was 1 second. UserName PasswordLastModDate PasswordLastModTime --------------------- ------------------- ------------------- DBC 07/06/25 12:15:27 TDPUSER 07/06/25 12:24:25 SystemFe 07/06/25 12:24:31 SysAdmin 07/06/25 12:24:31 Crashdumps 07/06/25 12:29:01 Sys_Calendar 07/06/25 12:29:0