User Last Successful logon date and time

[Former Member]

Hello All,

We have a requirement to display Last successful logon date and time every time user logs on to the Portal. Datasource for the portal is SAP. I see few forums suggesting to use WCR_USERSTAT table, but i don't see this table being updated every time i logon to portal. Is there any work around for this?

Thanks,

Indrajit

[PuneetSaxena · Accepted solution]

Hi Indrajit

You can write your own custom app to store the value in DB for last login.

It'll be simple app JSP dynpage app which you can add in Masthead.

Thanks

puneet

[Former Member · Accepted solution]

Hi Puneet,

Thanks. Thats one of the options i am considering. Couple of concersn with that option are

1) i need to have another table created for it in Database and the whole maintenance that comes from it. Even if there is some table i can use to store this value, that would be ok as well. Let me know if you can think of any.

2) Ensuring the update happens only once during the login as the masthead keeps getting invoked everytime there is an iview selected.

let me know your thoughts.

Thanks,

Indrajit

[Former Member · Accepted solution]

Hi Indrajit,

1. Your concern is very genuine. If you are concerned with just the last login information, you can create a custom attribute for the user and store the information there. By this you can store only the last login information. Otherwise I cannot think beyond using a table to store this.

2. Login information will not get updated on the refresh of the masthead. I dont think this is an issue.

Regards,

Ganesh N

[Former Member · Accepted solution]

Hi Ganesh,

I dont seem to get much infomration on creating custom attributes. Can you share if you have any documents or links?

Thanks,

Indrajit

[Former Member · Accepted solution]

Hi Indrajit,

Here is the SAP document on adding new custom UME attributes.

[Adding custom UME attributes|http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/50018d40-d370-2910-3ba7-aa83038d257a]

Regards,

Ganesh N

[Former Member · Accepted solution]

Thanks Ganesh.

I would need documentation to update these attributes through custom java code. Can you help me with that.

Thanks,

Indrajit

Edited by: Indrajit HR on Jul 15, 2011 1:22 PM

[Former Member · Accepted solution]

Hi Indrajit,

These threads may be useful

Regards,

Ganesh N

[Former Member · Accepted solution]

Thanks Ganesh. Let me try this.

[former_member82178]

Hi IndraJit,

Have a look at below link, if it can help.

I guess, the only way to get the info is through WCR_USERSTAT table. Also, check if the aggregator application is running on portal which tries to collect the aggregated data.

http://help.sap.com/saphelp_nw04/helpdata/en/58/728ea01cf64fff996b827f2a06f9b1/content.htm

Thanks and regards,

Madhu Sudhan.