topic Re: Role usage report in Application Development and Automation Discussions

Role usage report

Sankar_Aravind — Tue, 18 Jul 2017 07:25:57 GMT

HI,

Is there any report/Way to identify the Role usage report ?

For ex: If I give the user ID as input , the report should show the output as

User ID and the tcode was not used from any of the roles since XX/XX/XXXX date. The whole idea is to identify how many roles are present to the user in which at least one tcode also not executed from years from that role. So that it will be helpful for cleanup.

Thanks,

Aravind.

Re: Role usage report

Former Member — Fri, 21 Jul 2017 04:07:37 GMT

Hi Aravind,

I guess there is no direct standard report that can fetch you the mentioned details.

What can be done instead as a workaround is to get the tcode usage information for the users from table GRACACTUSAGE and the tcode/roles assignment for users info from tables AGR_USERS, AGR_TCODES. Once downloaded to Excel you can extract the required data using various select/join statements.

Else, you can always go for a custom program 🙂

Thanks,

Akash