Skip to Content
0
Former Member
Nov 30, 2012 at 05:35 PM

Java UME report

67 Views

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 ?