Analytics report to track Unowned Entitlements

[adityachadde]

We are trying to create an Unowned Entitlements Report to track unowned Entitlements. If anyone created this kind of report, please give an analytics query or give some suggestions how we can capture these details using the query and create the reports

Thank You,

Aditya Chadde

[rushikeshvartak · Accepted solution]

select * from entitlement_values where entitlement_valuekey not in (select entitlement_valuekey from entitlement_owners)

[avinashchhetri]

Hi @adityachadde,

Please find below the documentation on the Saviynt Schema that will help you to understand the underlying tables and their relationships.

https://docs.saviyntcloud.com/bundle/SSM-DB-Schema-Reference-v55x/page/Content/Identity-Repository-S...

[adityachadde]

Hi @avinashchhetri,

Could you share the link where I could find the ER Diagram for the saviynt DB Schema to understand the underlying tables and their relationships?

Best Regards,

Aditya Chadde

[avinashchhetri]

Hi @adityachadde,

I have shared the link in my previous post. Anything specific you are looking for ?

[rushikeshvartak · Accepted solution]

https://saviynt.freshdesk.com/support/solutions/articles/43000521404-saviynt-enterprise-identity-clo...