Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Entitlement Campaign Configuration - Entitlement Query

VivekTangri
New Contributor II
New Contributor II

Hi,

I was looking under Data analyzer to get the attribute for queries that we specify under 'Advanced Campaign Configuration, but could not find any.
Under 'advanced campaign configurations', we need a report that gives us the 'entitlements query', 

Is it possible to create an analytics report for the above requirements ?

Regards,
Vivek

3 REPLIES 3

Saathvik
All-Star
All-Star

@VivekTangri : Entire Campaign configuration is stored in one column called CONFIGURATION_AS_JSON which will store configuration in JSON format in that you need to look for entQry to find out the query used in entitlement query

If you want to query launched campaign where entitlement query is used then use below query 

select campaign_name, CONFIGURATION_AS_JSON from campaign where (CONFIGURATION_AS_JSON like '%entQry":"%"%' and CONFIGURATION_AS_JSON not like '%entQry":""%' )

If you want to query a campaign template where entitlement query is used then use below query 

select TEMPLATENAME, CONFIGURATION_AS_JSON from campaign_templatewhere (CONFIGURATION_AS_JSON like '%entQry":"%"%' and CONFIGURATION_AS_JSON not like '%entQry":""%' )

Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

Use below query to get all configs Query 

select campaign_name ,

SUBSTRING_INDEX(SUBSTRING_INDEX(CONFIGURATION_AS_JSON, '"userQry":"', -1), '"', 1) AS 'Users Query',
SUBSTRING_INDEX(SUBSTRING_INDEX(CONFIGURATION_AS_JSON, '"accountQry":"', -1), '"', 1) AS 'Accounts Query',

SUBSTRING_INDEX(SUBSTRING_INDEX(CONFIGURATION_AS_JSON, '"entQry":"', -1), '"', 1) AS 'Entitlements Query',
SUBSTRING_INDEX(SUBSTRING_INDEX(CONFIGURATION_AS_JSON, '"roleQry":"', -1), '"', 1) AS 'Roles Query',
SUBSTRING_INDEX(SUBSTRING_INDEX(CONFIGURATION_AS_JSON, '"accountEnt1Qry":"', -1), '"', 1) AS 'Account Entitlements1 Query',
SUBSTRING_INDEX(SUBSTRING_INDEX(CONFIGURATION_AS_JSON, '"userQry":"', -1), '"', 1) AS 'Consult/Reassign User Query',
status
from campaign where id=617

rushikeshvartak_0-1713327104526.png

Refer https://forums.saviynt.com/t5/identity-governance/sql-query-required-assistance-in-getting-the-endpo...


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

VivekTangri
New Contributor II
New Contributor II

Thank you.