History log changes for unlock/lock users

[ldelrio]

Hello everyone.

I needed to find out if there was a way to see the unlocks/locks that occurred to users on the system.

The SUIM Users establishes the modification for me, but I was looking for another table that also indicates it.

I tried with the USH02 but it shows the record of the change but not what specific change was made, and also using the CDHDR and CDPOS but these do not show me the modifications that I want.

So my question is to know if there is any other table that can be used to see this type of change.

Greetings.

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

[Neeraj_Jain]

Hello ldelrio,

Please check transaction AUT10.

Regards,

Neeraj Jain

[Mofizur]

Hi,

You can play around with USR02. I have my backend SQL Server - so this is the kind of query I normally use to get the necessary data. My requirement is only for the SYSTEM Account.

SELECT [MANDT]

,[BNAME]

,[UFLAG]

,[USTYP]

,[TRDAT]

,[PWDCHGDATE]

FROM [YYY].[yyy].[USR02]

--where BNAME not like '%[0-9]%'

--where TRDAT<20230223

where UFLAG=0

and [USTYP] NOT IN ( 'A')

order by [PWDCHGDATE] desc

-- order by [TRDAT] desc

Thanks,

Mofizur