Skip to Content
Former Member
Feb 12, 2014 at 05:55 PM

How to read "date of last successful password logon"


Hi all,

we activated 'write Successful Logon Statistics' attribute to store detailed logon informations.

Now there are some nice new fields under Account informations page of a user.

we also found that these info are stored in UME_STRING table

now we have a simple question....

do you know which kind of API should be used to retrieve the "date of last succesful password logon"?

yes....the decription has a small difference between table and portal screen....but the value inside is the same and is what we need.

our objective is to create a report/application able to retrieve this info that can be used for audit and other purposes.

so...our question to read this value? API if exists or native SQL?


p.s. there are other API reading the WCR_USERSTAT containing the "lastlogondate" but the meaning is different because the highlighted date is populated when a locked user is attempting to logon....but not able to do it


user_admin.jpg (15.1 kB)
ume_string.png (14.0 kB)