Saviynt Forums

Rayomand · 03/06/2024

Hello, I am trying to update the rank of service account owners using enhanced query but its giving me the error as in the screen shot .selectao.ACCOUNTOWNERKEY as accountowners__primarykey,'26' as accountowners__RANKfromaccounts a,endpoints e,...

SQL User Hierarchy · 02/29/2024

I'm seeking assistance on a non-recursive query to retrieve a list of employees spanning three hierarchical levels downward from the CEO. The current recursive query I have employs a Common Table Expression (CTE) and retrieves relevant details from t...

Rayomand · 10/19/2023

Hello,I am trying to run this query once but the job keeps failing and I cant see any error , not sure what the issue isupdate users set username = SUBSTRING_INDEX(SUBSTRING_INDEX(username, '_', -3), '_', 1),email = SUBSTRING_INDEX(SUBSTRING_INDEX(em...

Rayomand · 06/05/2023

I am trying to create a custom sav role that will allow users to request on behalf of any user in the organization but only for a particular endpoint. (Role1)For other endpoints users can raise access requests only for their immediate team members.(R...

Rayomand · 03/07/2024

That's an entire process that will have to be written for tens of thousands of accounts that will have to be looked at with analytics, till then the csv bulk upload seems ok.

Rayomand · 03/07/2024

Do u have an example of how to add a user as an owner to the service account as a default action? also I cant see the "Primary" and "Secondary" certifiers as options to assign to a user

Re: SQL User Hierarchy · 03/05/2024

SELECTE.userkey,E.username, M1.username, M2.username, M3.usernameFROMuser AS ELEFT JOINuser AS M1 ON E.userkey = M1.managerLEFT JOINuser AS M2 ON E.userkey = M2.managerLEFT JOINuser AS M3 ON E.userkey = M3.manager;I am querying via the data analyzer ...

Rayomand · 10/22/2023

Hello, Is there an issue with "not in" sql condition ?as I tried to execute a query with it and it failed, as a test I just put "in" and it worked, if this is an issue I will have to re-write the query as the number of users for the condition t...

Rayomand · 10/20/2023

I ran the select before the update its working fine, the query u have used in ur reply is missing the inner query which is a crucial part,I am unable to find anything in the logs

Online Status	Offline
Date Last Visited	‎03/21/2024 01:31 AM

Saviynt Forums

User Statistics

User Activity

Enhanced Query Account Owners

SQL User Hierarchy

CUSTOMQUERYJOB Query

Custom Sav Roles : Limited for a particular endpoint

Re: Enhanced Query Account Owners

Re: Enhanced Query Account Owners

Re: SQL User Hierarchy

Re: CUSTOMQUERYJOB Query

Re: CUSTOMQUERYJOB Query