How to get the account type?

[TCooper]

Hi, this query did not work for us.
https://forums.saviynt.com/t5/identity-governance/account-name-in-the-entitlement-type-filter/m-p/80...

This query gives all accounts. We need to ensure that entitlements are appropriately displayed based on the type of account being accessed. For instance, privileged accounts should have access to a specific set of entitlements, while regular accounts should have access to another set. We have the dynamic attribute in the endoint , based on account we are selecting it should display account type in dynamic attribute. We would like to know how to get the account type. I also tried adding a custom property of “privileged” as the variable to help define whether entitlements should be shown or not but that also did not work. 

[This post has been edited by a Moderator to move to its own thread..]

[PremMahadikar]

Hi @TCooper ,

I assume you are doing update access request where account is already in Saviynt. Once the account is selected, account type of that account should be displayed.

The below query in dynamic attribute is working for me: please try

select distinct a.accounttype as ID from accounts a, user_accounts ua where a.accountkey=ua.accountkey and ua.userkey=${requestee} and a.endpointkey=3

Please hardcode the endpointkey for the application/endpoint you are using.

If this reply answers your question, please consider selecting Accept As Solution and hit kudos.

[TCooper]

Hi, 

That did not work for us. If a user has a privileged account, we would like for the user to automatically get access to the entitlement from ARS solely based on account type. Do you have any additional suggestions? 

[rushikeshvartak]

Can you share config tried 

[rushikeshvartak]

Is this for Service Account ?

[CR]

account type will display only service accounts and normall account dont have account type it is blank .

try to use service accoutn application , will get results.

select distinct a.accounttype as ID from accounts a, user_accounts ua where a.accountkey=ua.accountkey and a.endpointkey=13421 and ua.userkey=${requestee}