Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

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 this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.