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

SQL query is getting populated in service account name

manishka
New Contributor
New Contributor

We are working on managing service account module .here we are validating service account name value based on the value of service account name rule provided at endpoint value.

when we placed a sql query in our dynamic attribute, that query is getting populated there instead of value output of query. This is stopping us from getting the desired result.

Is it expected or something we are missing? 

 

4 REPLIES 4

Saathvik
All-Star
All-Star

@manishka : Can you provide more details with screenshot or something. I know there is a known bug in Service account name field where it shows the rule you configured on endpoint instead of value until you click on generate button which is introduced in some 24.x version and fixed in v24.3. Not sure if you referring to same thing or different.


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

Can you share CONFIG screenshot


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

manishka
New Contributor
New Contributor

Hi Rushi,

We are working on generation of service account name via endpoint's service account name rule. There we are calling dynamic attribute. Also we are not able to call below query:

select username from users where userkey='${requestee}'

SQL Query is not supported there it should be groovy

Sample - Azure-SVC-${appname.replace(" ", "")}-${environment}${additional_naming_criteria=='' ? '':'-'}${additional_naming_criteria}###INCREMENTINDEX###${environment=='DEV' ? '@rushi.az':(environment=='TEST' ? '@rushi.az':(environment=='PROD' ? '@rushi.cl':''))}


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