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

JSON / SQL code for A SQL Connection in Saviynt

axelB
New Contributor III
New Contributor III

Hello,

What is the code to retrieve a attribute from the manager of a USER in saviynt for a SQL Connection?

With an Active Directory connection we are able to do this : 

"manager": "${managerAccount?.accountID}"

But in the SQL DB connection : the following is not working

__99__eco_mgr_emp_number='${managerAccount?.customproperty26}'

while retrievel of the user info attributes just works fine : __99__eco_emp_number='${user.customproperty26}'

Can you please share what has to be used for SQL Connection and the jason/code to use?

We also can't find any kind of documentation on how the syntax of the code should be for for example, SQL db connection, or Active Directory connection, etc... So examples and documentation on this would be helpfull?

thanks

Axel

axelB_0-1709281694865.png

 

10 REPLIES 10

Raghu
All-Star
All-Star

@axelB  you can do it like this it work,

Manager":"${manager==null?"":manager.username}",

if use managerAccount.accountid means it expecting OU structure.

 

https://forums.saviynt.com/t5/identity-governance/how-to-provision-active-directory-account-with-use...

https://forums.saviynt.com/t5/third-party-access-governance/ad-account-creation-with-user-s-manager-...

 

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

axelB
New Contributor III
New Contributor III

Hello,

you gave a solution for a Active Directory connector (which is already working), but i am talking about a SQL Connector.

this syntax is not working (the bold part you suggested) :

 

{"UpdateAccountQry" : "UPDATE dbo.TEST_ESSUSERBROKENOUT
SET user_id='${user.systemUserName}' ,__99__eco_emp_number='${manager==null?"":manager.customproperty26}'
WHERE user_id='${user.systemUserName}'"}

axelB_0-1709308821404.png

 

 

 

 

 

 

 

may i know which property mapped manager column ?


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Raghu
All-Star
All-Star

if storing manager username in cp26 then try cp26 value

try below's

${manager.customproperty26}

or

${user.manager.customproperty26}

or

${manager.username}

or

${user.manager.username}


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

axelB
New Contributor III
New Contributor III

we need to map customproperty26 of the manager of a USER in saviynt, and this to a column in sql called __99__eco_emp_number

if you need any other print screens, just let me know

try below

${manager.customproperty26}

or

${user.manager.customproperty26}


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

axelB
New Contributor III
New Contributor III

Hello, can you please ask your colleagues what the correct syntax should be?

axelB
New Contributor III
New Contributor III

i just tried both, but give me same error : 

 

axelB_0-1709310853612.png

 

axelB
New Contributor III
New Contributor III

also tried to see if it could find another property, like the username , also not working:

so the syntax must be wrong to call for a property of the manager:

axelB_1-1709311426102.png

 

axelB
New Contributor III
New Contributor III

To everyone who is interested : the sollution is not the suggestion from above, but this syntax works:

__99__eco_mgr_emp_number='${usersManagerObj?.customproperty26}'

 

topic can be closed