Is there a way in Suim to get a listing of all the trans. for all users

[Former Member]

I know in Suim you can get a listing of all the transactions for a specific user.

This is done for each specific user

Is there a way to get a listing of all the users with all their transactions in one report.

Thanks

Joe

[sdipanjan]

Transaction assignment for Mass users (not for a single) can be found by using tables I hope... much better than SUIM:

Join the following tables in SQVI:

AGR_USERS & AGR_TCODES for the common field AGR Name. You will get the details from the alias table of these two.

(search the forum for more discussions on SQVI)

Regards,

Dipanjan

[Former Member]

Dipanjan

We also have a lot of profiles created with SU02 that were added to users.

Which table would I need to add to my joining of

agr_users & agr_tcodes.

Thanks

Joe

[sdipanjan]

Joe,

In which release your are? Please let me know for further suggestions.

To get details of assigned profiles, you can use the following tables:

USR10 and USR11. No need to join them.

You can also user RSUSR020, RSUSR010, RSUSR011.

Regards,

Dipanjan

[Former Member]

Dipanjan

We're on 4.6c

So there's now way to create a report with profiles created with PFCG and profiles created with SU02.

Thanks

Joe

[sdipanjan]

Joe,

You can check with the following tables:

UST10C User master: Composite profiles

UST10S User master: Single profiles

Try to make a query with any of the above table with USR10 or USR11. (I am not logged into check them) So please let me know if you get this helpful.

How many users are their?

Regards,

Dipanjan

[former_member701183]

Hi,

I dont think a list can be generated the way you require in SUIM. For this the best and quickest option is the table joining as mentioned by Dipanjan via SQVI. It will be faster as data will be directly fetched from Table where as suim is a report. Hence run query against the tables to get the requisite data.

Regards

Aveek.