Portal users log on details of last one week

[Former Member]

Hi Gurus,

Please help me to solve 2 pblms

1. how to get last one week successful log in details of users in the portal using webdynpro for java.

2. how to run a webdynpro application in the background when a user log in to the portal.

Thanks & regards

Vipin

[Former Member · Accepted solution]

hi,

i have solution for second quetion.

you have web dynpro application.

1. make iview from web dynpro application.

2.attach that i view to default fram work page.

3.dont mack ivew as invisible(make size of ivew to zero--hight and width)

this is best solution for this,

if you have any another problem let me know.

jayesh talreja

[Former Member · Accepted solution]

Hi,

Thanks for the updation, it was very helpful..

i have one more question

How to get the details of the actions performed by a user after logged in to the portal. Is KM portal provides any standard reports for this or how to achieve this thru wedbynpro.

Thanks & Regards

Vipin

[former_member82178 · Accepted solution]

Hi Vipin

I think the iview "Portal Activity Report" meets your requirement. check the below link which expains about "How to create/configure Portal Activity Report"

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

Otherwise, we can create customized reports (like users logon details of last one week & actions performed by users after logon ) with direct access to database tables, check the below link

http://help.sap.com/saphelp_nw04/helpdata/en/48/6aa9429b930b31e10000000a1550b0/frameset.htm

Here is the code, which we can use in webdynpro to get the required info

Connection con=null;

Statement stmt=null;

ResultSet rs=null;

try{

InitialContext ctx=new InitialContext();

DataSource ds=(DataSource)ctx.lookup("jdbc/SAP/BC_JMS");

con=ds.getConnection();

stmt=con.createStatement();

rs=stmt.executeQuery(SELECT TIMESTAMPHOUR,LOGONID FROM WCR_USERSTAT WHERE AGGREGATIONLEVEL = 'm');

while(rs.next()){

//Iterate through result set to get the required information, once we got Logon ID we can use UME API to get

//user details

}

Let me know if you have any questions

Thanks,

Madhu

[Former Member]

Hi Madhu,

It was very helpful information , thanks for the support

Vipin