Find Logged in Users on Previous day or any Particular date

[former_member188326]

We would like to know if there is a way to find out <b>which users have logged in to portal on a particular day</b>. The Standard Activity report in User Administration <b>just mentions that of the current day.

</b>

Firstly, is there a configuration available to do so?

Secondly, Is there an API available for this if there is no configuration.

If these dont work, there exist some WCR tables which we can query..... I just want to know if any table stores the daily logged in details of a user in seperate records? Or does it update the same record...

[Former Member]

Hi Bharat,

U can configure the report period. refer the blogs

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/124 [original link is broken]

Regards,

Tamil K

[former_member188326]

Hi Venthan,

We have already gone through the first blog. And the second needs authorization showing the message "Not Authorized".

Thanks,

Bharat.

[former_member82178]

Hi Bharat,

Security.log is created on portal server for logging import security events such as successful and failed user logons, and creation or modification of users,groups and roles. Location in file system: <J2EE-installation>\j2ee\cluster\serverX\log\system\security.log

Entries in the log file has the following format [TIME STAMP][SEVERITY][ACTOR][EVENT][OBJECT TYPE]=[OBJECTID][OBJECTNAME][DETAILS] for Ex: Oct 09,2007 3:47:25 PM | Info | <UserLogon> | LOGIN.OK | USER = ...| ......| TestUser01?

TIMESTAMP values can be used to get the logged in user information during specified period

Thanks,

Madhu.

[Former Member]

The portal activity report can be setup to run against any date range you like - you modify the settings of the iview accordingly but it is not going to give you a list of user ids ...... just the number of unique users who logged on in any particular hour.

Haydn

[former_member188326]

Hi Haydn,

The Portal Activity Report does not suffice out requirement we also want the User id's who had logged in. Is that possible to get the user id's of users through coding or fetching from the database table? If so than give us the table name.

Thanks for reply.

Bharat