Question Re: User last logon table in Technology Q&A

User last logon table

Former Member — Tue, 14 Jun 2011 09:19:31 GMT

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,

Re: User last logon table

former_member182598 — Tue, 14 Jun 2011 11:12:40 GMT

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

Thanks

Prashant

Re: User last logon table

SrinivasanVelumani — Tue, 05 Jul 2011 05:36:00 GMT

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

Re: User last logon table

Former Member — Tue, 05 Jul 2011 05:56:52 GMT

Hi,

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

Regards,

Jigar Oza

Re: User last logon table

Former Member — Wed, 14 Aug 2013 11:00:06 GMT

Hi,

You can also use the table USR02 for these details.

Re: User last logon table

hofmann — Mon, 19 Aug 2013 20:09:40 GMT

USR02? That's not a portal database table.