Campaign data in Saviynt for review

[pradeeppalagiri]

We are using below campaigns. We want to review the Saviynt data with campaign data. Can we extract with custom queries from Saviynt ?.

1. user manager campaign

List of all the users associated for a manager and associated accounts and entitlement access.

example : 

Certifier

User First Name

User Last Name

Account Name

Entitlement Value

Entitlement Description

Endpoint Name

  2. Entitlement Owner Campaign

For campaign data review of entitlement owner campaign , need data from saviynt for entitlement owner associated accounts and entitlements. 

for example :

Certifier

Entitlement Value

Account Name

User Email

User Manager

User Title

Username

3. Appmetadaowner campaign .

All the meta data details associated for the application owner. 

Entitlement Value

Entitlement Type

Endpoint

Description

User Custom Property 3

User Custom Property 4

User Custom Property 5

User Custom Property 6

[Manu269]

@pradeeppalagiri did you check below posts :

Campaign Report Queries - Saviynt Forums - 50171

Solved: UM Campaign Data - Analytics Report - Saviynt Forums - 54339

Frequently used Campaign Reports based on Campaign... - Saviynt Forums - 28534

How To - Create Frequently used Campaign/Certifica... - Saviynt Forums - 29145

How to create summary report for Role Owner campai... - Saviynt Forums - 49966

How to download Campaign overall summary report fo... - Saviynt Forums - 29693

[rushikeshvartak]

You can use saviynt default export option

[pradeeppalagiri]

Hi,

In the application owner campaign type, once we launched Campaign then export data file we can see data as below. We can see BASE ACCOUNT as entitlement Name and with actual entitlement value for an account. 

Campaign export sample data 

AccountName	EndPointName	Entitlement Name
Account1	ApplicationName	BASE ACCOUNT
Account1	ApplicationName	stream Persona- CST/Engg/Interface

When we create custom analytical report, we can see report data as entitlements associated with account name as below with single row. 

Sample custom analytical Report

ACCOUNTNAME	ENTITLEMENT_VALUE	ENDPOINT NAME
Account1	stream Persona- CST/Engg/Interface	Application Name

How to get BASE ACCOUNT in the analytical report when user account has an entitlement value associated?

Please suggest the query to get a BASE ACCOUNT when user account associated with an entitlement. Please find below sample query which i used. 

SELECT u.username as ApplicationOwner, A.NAME AS 'ACCOUNTNAME',ev.ENTITLEMENT_VALUE,E.Endpointname AS 'Endpoint Name' FROM ACCOUNTS A, USER_ACCOUNTS UA, ENDPOINTS E, Entitlement_values ev, account_entitlements1 ae1,endpoint_certifier ec, USERS U WHERE A.ENDPOINTKEY = E.ENDPOINTKEY AND ae1.accountkey = a.accountkey and A.ACCOUNTKEY = UA.ACCOUNTKEY and ae1.entitlement_valuekey = ev.entitlement_valuekey and ec.endpointkey=e.endpointkey and ec.userkey=u.userkey and a.ACCOUNTTYPE='Orphan Account' and a.status=1 and (ev.customproperty3='N' or ev.customproperty3='' or ev.customproperty3 is null)

Thank you & Regards

Pradeep

[rushikeshvartak]

SELECT u.username as ApplicationOwner, A.NAME AS 'ACCOUNTNAME',ev.ENTITLEMENT_VALUE,E.Endpointname AS 'Endpoint Name' FROM ACCOUNTS A, USER_ACCOUNTS UA, ENDPOINTS E, Entitlement_values ev, account_entitlements1 ae1,endpoint_certifier ec, USERS U WHERE A.ENDPOINTKEY = E.ENDPOINTKEY AND ae1.accountkey = a.accountkey and A.ACCOUNTKEY = UA.ACCOUNTKEY and ae1.entitlement_valuekey = ev.entitlement_valuekey and ec.endpointkey=e.endpointkey and ec.userkey=u.userkey and a.ACCOUNTTYPE='Orphan Account' and a.status=1 and (ev.customproperty3='N' or ev.customproperty3='' or ev.customproperty3 is null)

union

SELECT distinct u.username as ApplicationOwner, A.NAME AS 'ACCOUNTNAME', 'BASE ACCOUNT' as ENTITLEMENT_VALUE,E.Endpointname AS 'Endpoint Name' FROM ACCOUNTS A, USER_ACCOUNTS UA, ENDPOINTS E, Entitlement_values ev, account_entitlements1 ae1,endpoint_certifier ec, USERS U WHERE A.ENDPOINTKEY = E.ENDPOINTKEY AND ae1.accountkey = a.accountkey and A.ACCOUNTKEY = UA.ACCOUNTKEY and ae1.entitlement_valuekey = ev.entitlement_valuekey and ec.endpointkey=e.endpointkey and ec.userkey=u.userkey and a.ACCOUNTTYPE='Orphan Account' and a.status=1 and (ev.customproperty3='N' or ev.customproperty3='' or ev.customproperty3 is null)