Skip to Content

can idm execute the programs or report?

Oct 26, 2017 at 07:13 AM


avatar image

Dear Experts,

I would like to execute the report RSUSR003 SAP ABAP Report - Check the Passwords of Standard Users in All Clients from sap idm.

Can you please let me know whether we can execute programs or report available in sap from idm side?

if Yes, can you please let us know how we can excute

if No, can you let me know how we can get it from accessing tables. I am able to retrieve users info from the USR02 table but unable to get the password status text like below. And also if i try to access from table, i can retrieve only from that respective client but not from all the clients.



10 |10000 characters needed characters left characters exceeded

Hello DP,

could you detail more, what you mean by "unable to get the password status text like below"?




* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Matt Pollicove
Oct 26, 2017 at 11:41 AM

Hi DP,

So this is not an easy answer...

If there is a way to call the report via API or command line, then yes, you could do it via a generic pass or a shell execute pass. It will probably be a little slow, but you could get it to work assuming all you are looking for is to generate a report file. If the IDM dispatcher has access to the location where the report is being generated, you can even email it to people.

Accessing the database tables is theoretically possible, but I never seen really good success.

The way that I would probably try to do it (and have done with some other modules, but different use cases) is to have a BASIS type person access the data via PI / XI and place it in a table that IDM can access. Then you can access the file or table and do what you want with it.

This could be made more difficult depending on what type of data you are trying to access. If it's security related there could be different access levels or encryption details to deal with.

Hope this helps somewhat...


Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Matt, for your response.