Question Re: SQVI- help for learn in Technology Q&A

SQVI- help for learn

former_member797156 — Sun, 04 Feb 2024 02:15:46 GMT

hello,

how to list the frequency of use of a transaction and the role to which they are assigned for a user?

I need to create a sqvi to sort out my assigned roles.

I need to know:

the roles assigned to a user

the presence of transactions in roles

the frequency of use of the transaction.

I have used the tables agr_users , agr_1251 and ztransac_usage_m but the result is not good because more than 160000 hits and roles not assigned to the user.

Re: SQVI- help for learn

TammyPowlas — Mon, 03 Jan 2022 12:59:20 GMT

For the first 2 items, I wouldn't use SQVI; I would just run transaction SUIM

For the last one, there are various options (not using SQVI) - so far this one appears the best: https://blogs.sap.com/2013/06/11/how-to-use-stad-to-show-historical-data/

Re: SQVI- help for learn

former_member797156 — Mon, 03 Jan 2022 13:16:41 GMT

hi thanks for you answer, but i would like to know if what I want to do is possible from an sqvi to save analysis time.

I know how to do the analysis with suim but it's long and repetitive because of the number of roles

Re: SQVI- help for learn

TammyPowlas — Mon, 03 Jan 2022 13:26:33 GMT

The tables you are using should work - are you eliminating deleted/inactive users from AGR_1251 - see this thread: https://answers.sap.com/questions/6829049/index.html