Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/23/2024 03:58 AM
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 |
04/23/2024 04:11 AM
@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
04/23/2024 05:55 AM
You can use saviynt default export option
06/17/2024 12:47 PM
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
06/17/2024 06:36 PM
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)