cancel
Showing results for 
Search instead for 
Did you mean: 

Workload Reports

Former Member
0 Kudos

Hi All,

Our client is intersted in seeing the following reports:

1. Reports showing roles that are not being used

2. Report showing users that uses the system the most by role

3. Report showing the roles used the most for each user

4. How many times a t-code was excecuted say in one month or a week (please dont tell me to look at the number of steps and guesstimate from that )

I'm an Oracle DBA and writting sql scripts will not be an issue but my questions is that what underlining table(s) can I query to get these reports? I can get a the list of roles associated with t-codes from Security team.

If anyone has any idea, i would really apperciate it.

Munit

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182098
Active Contributor
0 Kudos

Make use of SUIM transaction code

Note that all user related table starts with USR*

and authorization related starts with AGR_*

See those tables in SE16

Regards,

Ravi