JSON / SQL code for A SQL Connection in Saviynt

[axelB]

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

[Raghu]

@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-...

[axelB]

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}'"}

[Raghu]

may i know which property mapped manager column ?

[Raghu]

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}

[axelB]

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

[Raghu]

try below

${manager.customproperty26}

or

${user.manager.customproperty26}

[axelB]

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

[axelB]

i just tried both, but give me same error : 

[axelB]

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 · Accepted solution]

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