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

Dynamic attribute in Endpoint SQL for username/endpoint

aro
Regular Contributor
Regular Contributor

In one endpoint I have a Dynamic Attribute of type "Single Select From SQL Query".

How can I access these automatically created and calculated fields "Security System", "Endpoint", "Account Name" and "Username" from the ARS Request Form via SQL?

aro_0-1664389922078.png

I have tried different variants without success like:

select count(*) from accounts where name like CONCAT(${username},'%')

What is the right syntax?

We use Saviynt v5.5SP3

1 REPLY 1

rushikeshvartak
All-Star
All-Star

select username as id from users where userkey= ${requestee.userkey} & There is no variable available for endpoint


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