05-21-2009 8:40 AM
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!
05-21-2009 8:48 AM
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
05-21-2009 8:48 AM
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
05-21-2009 9:47 AM
05-21-2009 11:58 AM
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.
05-23-2009 7:59 PM
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
05-21-2009 10:01 AM
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
05-21-2009 10:08 AM
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
05-21-2009 11:33 AM
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