SQVI- help for learn

[former_member797156]

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.

[TammyPowlas]

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/

[former_member797156]

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

[TammyPowlas]

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