Saviynt Forums

Sushma · 04/03/2024

Hi All, We need a query to get list of all the active users from a ZONE example ABC.Here we need list of all the users with Active AD account ,users with Inactive AD account & user profiles with No accounts. I have tried with Union, but duplicates ar...

Sushma · 02/22/2024

Hi All, Currently we have requirement to identify duplicate users with same locationdesc.Can you help me with the query? So far I have tried below query- select username,locationdesc from users where locationdesc in(select locationdesc from users whe...

Sushma · 02/06/2024

Hi AllIn most of the AD connections we are using SSl certificates. But as we see they are already expired but still connection is working.Can you explain is this expected behavior/How does it work as document says a connection with an expired certifi...

Sushma · 01/31/2024

Hi All, I'm getting below error while executing a query similar to below in data analyser.Error-Error : execute command denied to user 'abc'@'%' for routine Saviynt.ABCgenerateaaaSAMAccountname_contractor The same query works in Prod but throws abov...

Sushma · 01/30/2024

Hi team, Can you please help with a CSV template to upload Enterprise Roles from Roles Tab in EIC.Also please provide the steps to upload.

Sushma · 02/22/2024

Hi @naveenss ,Thanks for the response.It's giving users with null locationdesc as well.I tried with not null command still I could see null locationdesc.

Sushma · 02/06/2024

Hi All, Thanks for the reply.Actually in DEV instance, custom tables are not defined so It was throwing authorization error.The same query worked in Prod as we have custom tables defined there.

Sushma · 01/11/2024

Hi @Manu269 These solutions don't work in this case, as we have bulk orphan accounts to map.

Sushma · 01/11/2024

Hi @dgandhi @Manu269 ,I was able to extract orphan accounts for a specific endpoint.Now we have to correlate to users, here the problem is automatically not getting correlated as email is incorrect(correlation rule-users email mapped to accounts emai...

Sushma · 12/05/2023

Hi Ankky,I have found that we are not passing any value in "countrycode" in AD.For this user, country code was present somehow and I have removed the same and retriggered the task. It's success now. So if we pass null instead of value (map1.put("cou...

Online Status	Offline
Date Last Visited	‎04/04/2024 11:18 AM

Saviynt Forums

User Statistics

User Activity

Need help with the query=List of active users

Need assistance on query

Question on SSL Certificate

execute command denied to user data analyzer error

Uploading Enterprise roles

Re: Need assistance on query

Re: execute command denied to user data analyzer error

Re: Get list of users without an specific endpoint

Re: Get list of users without an specific endpoint

Re: LDAP: error code 21 - 00000057: LdapErr: DSID-0C0911BC, comment: Error in attribute conversion o