Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Report of Inactive users

Former Member
0 Kudos

Hi

How to extract the users list who are inactive in the month of Nov,Jan and Feb. Have to filter the users month wise of the past month.how is it possible..

Thanks in Advance!

1 ACCEPTED SOLUTION

Former Member
0 Kudos

If you are referring to users who have also subsequently remained inactive since November, or December etc, then transaction RSUSR200 (or the report by the same name in older releases).

Cheers,

Julius

7 REPLIES 7

Former Member
0 Kudos

If you are referring to users who have also subsequently remained inactive since November, or December etc, then transaction RSUSR200 (or the report by the same name in older releases).

Cheers,

Julius

0 Kudos

I want to extract only for the month of November..not since November

0 Kudos

Hi Naveen,

Julius has told you the correct transaction / report, but to get such a specific set of users that haven't used SAP in a particular month seems a strange query. You can get such information if you run RSUSR200 on a monthly basis, but if you are not doing such monthly checks then there is no easy way of doing this.

We have some bespoke code on our systems, that track user usage by date, so we can see if a user has been active in a specific month, but that was for a specific audit requirement and it also underpins our fire fight system (which we developed before the Virsa / SAP solution came along).

Going back to Julius' original point, RSUSR200 will show you every user and when they were last active on a system, so running this at the end of each month, will show you who didn't access SAP in that month - but it will also show you everyone else who also had not accessed SAP in previous months too.

If someone is not using SAP, surely the month they are not using it is not really important. If it is you might have to develop some monthly processing, which you can use going forward.

0 Kudos

Good comments - there is also a difference between inactive as being "not logging on" and inactive as "not processing anything".

With some effort you could map the user assignment to roles in various functional areas, and then evaluate the transaction data (or master data if that is their job) to sort them by the most active.

However this is notoriously bugged by batch programs, workflow, external services, etc which can distort the statistics. Even badly written programs with poor response times (SELECT * FROM <huge table>... ) can drive a whole hard working country up the wall...

Cheers,

Julius

Former Member
0 Kudos

T-code SUIM

Change document

For user

Select Date period which want

Uncheck all

Under selection criteria for change authorization

Select deleted user (Inactive also come under delete)

Under selection criteria for changed header data

Validity Period

Former Member
0 Kudos

Hi Naveen,

If you are looking for the users whose user group is INACTIVE in SAP, then I guess the below mentioned steps should help you.

You can get a list of INACTIVE users for a particular month through USR02 table.

Go to the table USR02, and enter the user group as inactive, and the last logon date as the 1st Nov to 30th Nov. and execute.

Hope this helps.

Sneha Vyas

Former Member
0 Kudos

Hi Naveen

Use SA38 to run RSUSR200.

This report is part of the AIS (Audit Information System) and will report users who have not logged on for a specified period of time

Thx

Shilpa