ShlomoKatz (Customer) asked a question.

January 30, 2024 at 1:54 AM
I am looing for a report, or a way to determine, all the roles containing an entitlement specifically a group collected by the AD collector. I do not want to combine multiple tables.
If version specific: 8 P01

Thank you
  • 4 answers
  • 218 views

  • TimWillemstein2 (Customer)

    I don't have a query at hand, but this view "PV_ROLE_ENTITLEMENT" has all mappings between roles and their entitlements, map this to the "PV_USER_GROUP" view and the "PV_ROLE" view and I suppose you have everything you need to get the specific AD Collector and what groups are linked to what roles for it.

    Selected as Best

  • TimWillemstein2 (Customer)

    Is there a specific reason why you don't want to use multiple tables?

    • ShlomoKatz (Customer)

      Hello Tim,

      I have a lot of projects, if you have a query already, that will be a big help. :-)

      It is a matter of timing, but if you have the table names I need to link, I can start there.

  • TimWillemstein2 (Customer)

    I don't have a query at hand, but this view "PV_ROLE_ENTITLEMENT" has all mappings between roles and their entitlements, map this to the "PV_USER_GROUP" view and the "PV_ROLE" view and I suppose you have everything you need to get the specific AD Collector and what groups are linked to what roles for it.

    Selected as Best

  • ShlomoKatz (Customer)

    Thank you ! Those were the tables I was looking for.

     

Don't see what you're looking for?