Import Account query - Account type

[GauravJain]

Hi

We are trying to onboard Active Directory (AD) onto Saviynt. Our AD environment manages various account types like Human / Privileged / Service etc. but there is no attribute by which we can distinguish these account types.

How do we manage them in Saviynt while importing? 

Secondly, in another target system we have account type values as "A" and "B" for human and service account respectively. is it possible to convert those values to "Human Account" and "Service Account" while account import? If not, any other alternative to achieve this?

Regards

Gaurav

[pmahalle]

@GauravJain ,

What type of target having values as A and B as account type which you want to import as Human Account" and "Service Account" ?

[GauravJain]

Its ServiceNow - values are not as "A" and "B" but they are just one character value and i want to convert them into "Human Account" and "Service Account".

[rushikeshvartak · Accepted solution]

You can convert those using enhanced query

select accountkey as accounts__primarykey,case when accounttype='A' then 'Human Account' else 'Service Account' end as accounts__accounttype from accounts where accounttype in ('A') limit 1;

[GauravJain]

thanks @rushikeshvartak . i will try this and revert. Is it the only approach we have? Can we use IF/Else condition or ternary operator in ACCOUNT_ATTRIBUTE mapping?

[rushikeshvartak]

CONST not supported in LDAP/AD Connector hence only enhanced Query

[GauravJain]

How about IF/Else condition or ternary operator?

[rushikeshvartak]

No string operations