Getting a users last logon date?

[russell_turner5]

Hi,

I've been hunting for a way of getting a list of portal users and their last logon dates. Is this still possible?

I have seen the UME API  but the getLastSuccessfulLogonDate method of IUserAccoun is now depricated.

I've seen the wiki entry Direct Access to Database Tables - Code Gallery - SCN Wiki for reading tables directly, but the tables listed in help :

Direct Access to Database Tables - SAP NetWeaver Portal - SAP Library

don't seem to contain the last successful login. Anyone help?

Cheers,

Russ.

[cris_hansen · Accepted solution]

Hello Russ,

In KBA 2155174 you should have some useful information.

Maybe you can look for ume.logon.securty_policy.* properties that help you finding what you need.

Regards,

Cris

[saar_dagan]

Hi Russel,

If you have portal activity on and you have a landing page for all users you can use the monitor hits/monitor page properties on the landing page to know "mark" each user logon and then using simple SQL query you can ask the DB tables of activity report when was user last logon.

BR,

Saar

[Former Member]

Hi Russ,

The UME API method getLastSuccessfulLogonDate is deprecated, because it does not return valid information, unless you configure your system to write last successful logon date. This can be done by the security service property 'write Successful Logon Statistics'. Please have in mind that this functionality is disabled by default as it is causing performance issues. For more information see SAP Note 982741.

Best regards,

Nikolay