Skip to Content
Jan 03, 2022 at 12:21 PM

SQVI- help for learn



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.