create a Portal activity report with aditional data?

[Former Member]

HI

I need to create a summary report of activity of Portal users.

I have seen the Portal Activity Report, but I need more information, such as: IP address of each connection, linking users currently logged with his activity on each page, bytes transfered in each request,

In this link

Http://help.sap.com/saphelp_nw70/helpdata/en/58/728ea01cf64fff996b827f2a06f9b1/frameset.htm

I saw the fields available, but some of those mentioned above, are not.

What is the simplest way to make that report?.

Where to find the information that I need?

thanks in advance !

regards

Edited by: Leandro Balboni on Jan 29, 2008 11:23 AM

[Former Member]

Hi,

Could you advise if the table mentioned such

as WCR* is available in R/3.Thanks

Cheers!

Stafford

[Former Member]

Hi Stafford,

Can you please specify your question, do you mean is there any way in R/3 that through it you can access the WCR* tables?

In generally WCR* tables are used for Activity Report portal service.

Regards,

Victoria Gur

[Former Member]

Hi ,

i need to get such additional data for portal role's accessed by number of users please suggesst

[Former Member]

puntually,

the IP addres for a Portal connection is logged in some table or file ?

any suggestion?

thanks

[PuneetSaxena]

Hi Leandro,

You can find information about which user logged in, which pages/ iViews he accessed from

WCR_AGGINFO

WCR_USERFIRSTLOGON

WCR_USERNODELOGON

WCR_USERNODESTAT

WCR_USERPAGEUSAGE

WCR_USERSTAT

WCR_WEBCNODESTAT

WCR_WEBCONTENTSTAT

These tables will give you information about that.

Thanks

Puneet

[Former Member]

thanks

but... I mentioned this tables in my post, my question is about specific fields for example IP address, where I can found it,

And, how can I import the out-of-the-box PAR file for Activity report and customize it.

[PuneetSaxena]

Hi,

Hope this will help you.

for (Iterator iter=action.getOnlineUsers(); iter.hasNext(); ) {

User user = (User)iter.next();

Presence presence = presenceManager.getPresence(user);

Country country = CountryLookup.getCountry(presence.getIPAddress());

}

Thanks

Puneet