User last logon table

[Former Member]

Hi experts,

Anyone knows what is the table where the portal stores the user last logon? The table WCR_USERFIRSTLOGON is for first logon, but... for the last logon?

Thanks in advance,

Regards,

[Former Member]

Hi,

You can also use the table  USR02 for these details.

[hofmann]

USR02? That's not a portal database table.

[former_member246153]

Hi Victor,

First thing there is no seperate table for getting User Last Logon information. But we can get the User Last Logon information

by fetching data from two Standard tables

1.WCR_WEBCONTENTSTAT

2.WCR_USERPAGEUSAGE. Using the Primary key of table 1 we can compare it the data with table2 to sort the Last Logon Date for the particular LoginID. Check it you will get a idea.

This works when all the iViews or Pages for the End-Users have Moniter Users property enabled.

Regards,

Nivas

Edited by: Nivas209 on Jul 5, 2011 7:41 AM

[Former Member]

Hi,

You can select the lastest entry based on loginid and timestamp from WCR_USERSTAT table to fetch last logon details.

Regards,

Jigar Oza

[former_member182598]

You can fetch this information from WCR_USERSTAT table. Sort on the Time Stamp to get the last Logon Date.

Thanks

Prashant