Accessing Portal APIs in WebDynpro

[Former Member]

Hi,

I am trying to build WebDynpro Applications that will display the Portal information , such as :

a) total number of portal users

b) users currently logged in

c) systems configured

d) portal runtime information , such as the pages accessed by user level

and more such information.

I am looking for the APIs that would help me in building such application.

Please help me out with the source from where I can get the details of such Portal APIs and how to use them.

Looking forward to help from SDNers.

Thnx,

Pravesh Puria.

[Former Member]

Hi,

WCR_USERSTAT,WCR_WEBCONTENTSTAT,WCR_USERFIRSTLOGON are the tables which contain this data. You can directly access these tables.

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/58/728ea01cf64fff996b827f2a06f9b1/frameset.htm">Portal Activity Report.. Direct access</a>

[Former Member]

Hi ,

How to get access to these tables , ie : from WebDynpro for Java coding.

I did see that Portal Activity Report feature , but for learning purpose I want to build my own application .

Please help me out .

Thnx,

Pravesh Puria.

[Former Member]

Hi,

Like we read any database table using java. In case your are looking for connecting to DB ..

Refer the link ..

In case of Oracle, please give a google search

The database SID is usually the SID of Web AS server. Go to this database and read the mentioned tables..

Regards

Bharathwaj