Last Transaction Accesed by User

[Former Member]

Hi Folks,

I want to find out a last transaction accessed by a user. I am on 4.6C I do not have CCMS logs neither do i have Audit logging enabled on my system and logs are older than a week so STAT/STAD is not an option.

Is there any table which would be able to provide me with such data?

Regards,

Chinmaya

[Former Member]

Hi,

You can find this in st03n

1. Open transaction ST03n

2. Switch to expert mode

3. Select application server or total (for all application servers) and the select date you wanted to check.

4. Now a small dialog box opens below that, select User and Settlement Statistics

5. Double click on user profile and find the user name you wanted to check.

6. Now again double click on the userid.

7. A dialog box will be displayed with all the transactions used.

Regards,

Gowrinadh

[Former Member]

Hi Govrinadh,

This gives me a lot of information like DB reas times etc. However it still dosent give me the last transactions called!!

Regards,

Chinmaya

[Former Member]

Hello Chinmaya,

Please execute report RSUSR200 in SA38.

Hope this help.

Regards,

Surpreet

[jurjen_heeck]

> Please execute report RSUSR200 in SA38.

Which will give what part of the requested information???????

[Former Member]

> Is there any table which would be able to provide me with such data?

There are many, but for this task they are all more or less unreliable as they are not really intended for it.

Wishing that it weren't that way won't help you, sorry to say.

They correct tool is the Security Audit Log (SM19 etc).

Cheers,

Julius

[Former Member]

Hi Julius,

Couldn't agree with you more about SM19, but as I said not something I can use at the moment.

If you could enlighten on the more unreliable method that would be great too.. I know it wont be reliable but may be worth a shot..

Best Wishes,

CP

[Former Member]

> I know it wont be reliable but may be worth a shot..

Hmmm... where to start - if you indicate why you need this and what type of access the user had, then it would help narrow it down:

Some idea / areas to check:

- Transaction data headers.

- Application change document objects.

- Short dumps.

- System logs.

- DB logs.

- GOS Object history.

I find it strange that your stat collectors are not working though. If someone deleted the jobs, then perhaps you can still recover the data. If you are lucky, then you can still find out who deleted the jobs via the ST11 trace.

Cheers,

Julius

[Former Member]

Sorry i pasted wrong report name, it is used for some other purpose.

Well you can use STAT for last two days.

Or ST03N -> Environment -> User -> System Wide (as in 4.6c)

Regards,

Surpreet

Edited by: Surpreet Singh Bal on Mar 12, 2009 9:50 PM

[Former Member]

Hey Supreet,

Thanks for the input but i did use ST03n in Expert mode today and it didnt give out any transactional data for the user. It gives DB access related data. I will however have another go at it in a while.

Best Wishes,

CP