Java UME report

[Former Member]

Hello,

I have a requirement to generate a report from JAVA UME apis.

I am aware of some standard function used to fetch information from UME tables.

But I need to know some points based on below report format which is required:

Host        Date        Time        User Name    Terminal name    Message Text

-------------------------------------------------------------------------------------------------

XXX.XXX.XXX.XX    10/30/2012    17:47:44    ABC        FCB-11966-L    User is locked due to incorrect logins

XXX.XXX.XXX.XX    10/31/2012    14:59:32    ABC        FCP-13539-L    User is locked due to incorrect logins

XXX.XXX.XXX.XX    10/31/2012    17:02:29    XYZ        FCP-17786-L    Incorrect Password

XXX.XXX.XXX.XX    10/31/2012    17:02:39    XYZ        FCP-17786-L    Incorrect Password

Now my queries are :

1. Is it possible to fetch terminal information from UME tables which user used while logging into system.

2. As in the table above, our client needs records for all login attempts of a user. Is such information maintained somewhere ? What I understand is that same record is updated each time user logs into UME. i.e. Suppose User ABC logs in on 20th Dec 2012 and his attempt was unsuccessfull. Now he again attempts to login on 21st Dec, again his login attempt was unsuccessfull.

Now our Client want two records as below :

Host        Date        Time        User Name    Terminal name    Message Text

------------------------------------------------------------------------------------------------------------------------

XXX.XXX.XXX.12    12/20/2012    17:47:44    ABC        FCB-11966-L    UnsuccessFull Attempt/Incorrect Password

XXX.XXX.XXX.13    12/21/2012    14:59:32    ABC        FCP-13539-L    UnsuccessFull Attempt/Incorrect Password

Basically they need information about each login attempt (in given time span). Is it possible..if yes, then which table contains this information.

3. I understand that whatever information is available in UME tables is in UME_STRINGS table.

   Is there any link somewhere which can explain me about this table. Also are there any other tables in UME ?

[former_member189631]

Saurabh,

It should be very much possible to generate such report in portal with logon par file customization.

You need add a custom program module in logon page to fetch the current IP address of the logged in system also the module should fetch the logged in information to update in the data base table.

Below is the java code to get the IP address of the current system.

  InetAddress myIP=InetAddress.getLocalHost();

  System.out.println("IP of my system is := "+myIP.getHostAddress());

Ram

[Former Member]

Ram,

We cannot do any customization on logon module.

Our client does not want customization on any sap standard modules.

Thus we only need to use standard UME APIs....

Can you guide me in that direction.....

[former_member189631]

Hi Saurabh,

I dont think the Host name, IP address information can be fetched from the standard table. I would suggest you to go with thecustom development. Also please cross check the attributes of the table UME_STRINGS.

Ram