AnsweredAssumed Answered

Which table or view does "unifiedents" refer to?

Question asked by George Kwakkernaat on Mar 25, 2020
Latest reply on Mar 26, 2020 by George Kwakkernaat

Like • Show 0 Likes0
Comment • 4

I'm creating a custom query for the "Revoke user entitlements" part of a "Provisioning - Termination" type rule.

The default available columns (pictured below) all start with "unifiedents".

I wish to use an SQL-development tool to test my queries against this table or view directly. Does anyone know what table or view is being referenced here?

Pradeep Kadambar

Mar 25, 2020 1:45 PM

Correct Answer

From IGL_7.2_Public_Database_Schema_Reference

See the reply in context

No one else had this question

Outcomes

Pradeep Kadambar

Mar 25, 2020 1:45 PM

From IGL_7.2_Public_Database_Schema_Reference

Actions

George Kwakkernaat @ Pradeep Kadambar on Mar 26, 2020 4:56 AM

Hi Pradeep,

Thanks for the quick response.

Just to verify: This would be the PV_UNIFIED_ENTITLEMENT view then, correct?
Because the database containts a couple of tables with very similiar names:

Actions

Pradeep Kadambar

@ George Kwakkernaat on Mar 25, 2020 3:17 PM

PV_ is the prefix for all views in public schema document.

V_ are the views used for out of the box reports.

1 person found this helpful

Actions

George Kwakkernaat @ Pradeep Kadambar on Mar 26, 2020 4:55 AM

Perfect, thank you Pradeep.

Actions

4 Replies

Pradeep Kadambar Mar 25, 2020 1:45 PM
Unmark Correct
Correct Answer
From IGL_7.2_Public_Database_Schema_Reference
Like • Show 1 Like1
Actions
- George Kwakkernaat @ Pradeep Kadambar on Mar 26, 2020 4:56 AM
  Mark Correct
  Correct Answer
  Hi Pradeep,
  
  Thanks for the quick response.
  Just to verify: This would be the PV_UNIFIED_ENTITLEMENT view then, correct?
  Because the database containts a couple of tables with very similiar names:
  Like • Show 0 Likes0
  Actions
  - Pradeep Kadambar @ George Kwakkernaat on Mar 25, 2020 3:17 PM
    Mark Correct
    Correct Answer
    PV_ is the prefix for all views in public schema document.
    
    V_ are the views used for out of the box reports.
    1 person found this helpful
    Like • Show 0 Likes0
    Actions
    - George Kwakkernaat @ Pradeep Kadambar on Mar 26, 2020 4:55 AM
      Mark Correct
      Correct Answer
      Perfect, thank you Pradeep.
      Like • Show 0 Likes0
      Actions

Which table or view does "unifiedents" refer to?

Outcomes

Related Content

Recommended Content