Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Hi Team,Need a query for all the active users having specific role like 'XXX' assigned and for a particular endpoint like 'ZZZ' along with entitlement value and the account name.Thanks,Sharanya V
Hi Team,Need a query that displays user's having account name starting with "A-" along with their corresponding roles and entitlements pertaining to that account .Thanks,Sharanya V
Hi @rushikeshvartak ,The above query which you have shared is using user_roles tables , but there is no user_roles table and the query is not giving the results. Thanks,Sharanya V
Hi Devan ,Thanks, for the query, I need the results to be displayed in a single line instead of concating them in one single line and also the report is displaying both active and inactive accounts on a particular system. If one account is active and...
Hi @rushikeshvartak ,The service account is orphan , can we delete via file upload. If yes, please let me know file format and the steps to execute the action.Thanks,Sharanya V
@rushikeshvartak This is just eg where I'm showing account name unique, but account names are different for each system, but I'm looking something where the query identifies user having more than one accounts in the same system/endpoint, it could ei...
Hi @rushikeshvartak ,Please check the below screenshot:Consider the above date , so the query should display only the highlighted ones where there is two accounts found for the same system/endpoint , but in this case it is displaying all the accounts...
