topic Re: User Activity & Role Activity in Application Development and Automation Discussions

User Activity & Role Activity

Former Member — Tue, 27 Jul 2010 10:26:58 GMT

Hi,

Under T-Code SUIM , we will see user activity and role activity , i want to know in which table both this things are stored ???

Ankesh

Re: User Activity & Role Activity

Former Member — Tue, 27 Jul 2010 11:31:06 GMT

Are you sure, you are not mistaken?

In SUIM I get every kind of report to users / roles / profiles / authorisations - comparisons, where-used-lists etc. but no activity!

Re: User Activity & Role Activity

Former Member — Tue, 27 Jul 2010 11:49:35 GMT

Hi Mylene,

I know , but i am looking for the table in which User Activity and Role Activity gets stored, tables for both this activity.

For more clarification i am pasting fields from relevant area.

For User Activity i am looking for :-

Role 	Date	  Time	Changed by	Type	User

For Role Activity I am looking for :-

Role	Date 	Time 	Changed By	Action	Transaction

Both u will get from SUIM , i am looking for their tables..????

Re: User Activity & Role Activity

Former Member — Tue, 27 Jul 2010 12:04:13 GMT

Cluster CDCLS, tables CDHDR, CDPOS.

For instance: if you are searching for change documents for roles, you can run report RC1CD100 on objectclass PFCG - give the role name as the object-ID.

Re: User Activity & Role Activity

Former Member — Tue, 27 Jul 2010 12:09:42 GMT

Hi,

You can easily find out the tables for this.

You go to ST05 t-code. check sql trac and Activate trace.

Then go to SUIM and execute what you want therre.

Then come back to ST05 and go for display trace option. You can see all the tables associate with this.

Regards,

Nikhil