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

Need sample query/config for fetching datasets from Dynamic attribute

Diptansu_Sinha
New Contributor II
New Contributor II

Hello Team , 

We have REST cyberark connector which holds safe names. We have another domain AD connector which holds AD groups. Now we have received Safe-AD groups mapping. So the expectation is people will request for safe only , but in background based on safe-AD group mapping they will get added to AD groups under AD endpoint. 

I know we can do it via EntitlementMapping but since bulk entitlement mapping is not available as an option. Please provide the configuration / query how to access dataset from dynamic attribute. Since we have created dataset with this safe-AD mapping details.

Seocndly, if you have any good design in mind to achieve this. Please let us know at the earliest.

2 REPLIES 2

krunalkadam
New Contributor III
New Contributor III

We have utilized the following query to retrieve values from a dataset in the Dynamic attribute, where the type is set as SQL Enum. This query can be adapted to meet your specific needs:

SELECT DISTINCT ATTRIBUTE1 AS ID, ATTRIBUTE2 AS description FROM dataset_values WHERE datasetname = '<your dataset name>' ORDER BY ATTRIBUTE1 ASC

Best regards,

Krunal Kadam

Should you find this information beneficial, please think about marking it as "Accept As Solution" and don’t hesitate to hit the kudos button.

rushikeshvartak
All-Star
All-Star

Query 

SELECT DISTINCT ATTRIBUTE1 AS ID, ATTRIBUTE2 AS inlinedescription FROM dataset_values WHERE datasetname = 'safeAD' ORDER BY ATTRIBUTE1 ASC

 

rushikeshvartak_0-1713399757563.png

 

 


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