and more in a single search tool across platforms. Read the announcement here. |
Hell,as we've upgraded to EIC, some of our crucial "Execute Extension Queries" needs to be updated/overwritten to be reused as an "Enhanced Query Execution job" .Can some please help us here and tell us how this can be managed?Please see for example ...
Hi, we added a new technical rule that had for filter the employeeid and was assigning an enterprise role to the employeeid listed in the condition.This is an example of the condition:Users.employeeid =1 OR Users.employeeid =2 OR Users.employeeid =3 ...
I'm trying to design to import users from Azure AD using Job "UserImport via a Connection (UserImportJob)."When I select Azure AD in External Connection, I don't see Incremental Import in JobType.On the other hand, I can see it when I select an app o...
Hi Team,We have a custom query which we are using for to update the manager details for the users and we need to modify the query but custom query job is not editable . We need to create EnhancedExecution Query but we are not able to form the below c...
User import job is running as per the schedule and in the UI its showing successfully.But when we go inside the job logs we see no records processed on the files. This is happen on intermittent, we could process the same file manually. Please sugges...
Hello Team,We got a new case in EIC that When an instance is switched over by performance issue, Running jobs will be failed without enddate and no notification also.Is there anyway that we could get notified from Analytics report When it's failed li...
Hi Team,We not able upload secondary manager from csv file.getting below error:it is expected ? confirm please ?we can't update FK without PK we aware of but any possible way have , around 400 users we have ?
Hi All,We are having few SAP applications integrated in our environment.We want to exclude one entitlement named PUBLIC while removing access as this is generic entitlement and cannot be removed and resulting in error every time.insufficient privileg...
Hi Experts,I am opening a service ticket on an account request. The ticket is being created properly. But when I am closing the ticket, the updated status is not getting reflected in Saviynt.Here are the details:Postman response after closing the tic...
Hi,I'm encountering at the moment to choose the job type and the type of import the issue below while creating a new job to import accounts and access from AD.My connection to AD is well created and the status of the connection is ok.Thank your for h...
Hi Team, We have a trigger chain job which has 13 jobs added to it as below. LDAPuserimportSaviynt_Internal,LDAPuserimportSaviynt_US_External,LDAPuserimportSaviynt_US_Managed_Vendor,LDAPuserimportSaviynt_US_Vendor,BeSEE_Internal,Managed_BeSEE,Managed...
Scenario: A user enters an ARS request for an Enterprise Role. When selecting the start date, there is also the option to choose the end date. Once the end date for the requested role is reached, a system task is not generated for the deprovisioning ...
Hi Team,Can you some help on Enhanced Query build for column update with via Case statement.Please find below SQL Scriptupdate accounts as ajoin user_accounts as ua on a.ACCOUNTKEY = ua.ACCOUNTKEYjoin users as u on ua.userkey = u.userkeyset a.CUSTOMP...
Dear Saviynt Forum Members,I hope this message finds you well. I am seeking clarification regarding the functionality of CustomQueryJob in the latest versions of Saviynt, specifically regarding updates to the 'users' table.In previous versions, we ha...
Hi All, I am trying to trigger Schema Entitlement Job via API. This job as per configuration requires to select the Schema File Job Type to be selected. We have created the job to "Import Entitlement_values". Job is running fine when is executed from...
HiRecently our saviynt version upgraded from 23.5 to 23.12, we're facing the problem with custom query jobs. In generally if any task is error out, we used to reopen and reprovision it. Below is the query we are using in custom query job. update arst...
Hi all, I want to schedule a job to send an email notification when the pending job reach at a certain point for example if pending job is greater than 20k. How can we achieve this. Thanks.
We are facing an issue while updating the Customproperty value of an entitlement to NULL using the enhanced query job. Instead of making the customproperty value void or blank, the job is updating it to the word "NULL"Please find the query we are usi...
Hello Saviynt Team, I wonder if anyone could help explain this job as what it is supposed to do? It was pushed after a new instance have been given to the customer. Upload job: "MT_eso9i0ofc0pc" I am also attaching the log. Thank you, dkongvon[This m...
Hello,We may need to provision about 50,000 tasks to Azure AD simultaneously.These tasks are primarily Add Access, including Create Account, Disable account, and Remove Access.To validate, we actually generated about 34,000 tasks and ran provisioning...
Hello Team, We are observing an issue where the user import job status is showing as success but the end date is not populating and also user details are not fectching please find the logs below: 2024-01-11T23:35:39+05:30-ecm-worker-rest.RestUtilSer...
Hi All, Can you help with cron expression, where we need to schedule a Job which should run at 8am UTC from Monday to Friday and at 9am UTC on Saturday and shouldn't run on Sunday.
When we execute an update query from Jobs inside Saviynt, the update query reflects in tables , is there any chance we can get a backup of the table before the date of running the update query?any possible way we can get the data on the table just be...
Hello,When importing user data, we've encountered a challenge where some users input UTF-8 characters outside the Basic Multilingual Plane (BMP), leading to import job failures.In light of this issue, what are the best practices and recommended appro...
Hello Team,We have scheduled a user import job to run for every 8 hours and we have seen that the job was not imported any user from 15-30 December.Is it possible to run the job for the past days which is from 15 December to 30 DecemberThanks in adva...
I was creating query to insert entitlement owner using enhanced query execution.insert intoentitlementitlement_owners (ENTITLEMENT_VALUEKEY, USERKEY, RANK)Selectev.entitlement_valuekey,u.userkey,'1'fromaccounts a,entitlement_values ev,user_accounts u...
Currently, we encounter an incident due to the data format change from our source db (from HR), then lead to the status of all users being inactive (statuskey = 0) when it is imported to IGA. Fortunately, our operator alerted when there are numerous ...
We have a new user update rule that update an Okta user account and then assign to a specific Okta group.While the user has been put into Okta group, certain actions will be triggered.However, recently, the Okta admin reported that the user account ...
Hi Team, We are facing issue at the time reconciliation of AD import, observed getting some error in log and Job also not ending properly in 23.9v Log Error: Error Logs : Invalid Reconciliation Field for groupImportMapping: entitlement_value_char. T...
We have a requirement to run the job at intervals of 1 hour and 15 minutes (equivalent to 75 minutes). Does anyone have insights on how we can accomplish this using a cron expression?
We onboard new employees using technical rules. which creates tasks for AD account and exchange mailbox provisioning. Exchange mailbox creation depends on AD account. We use a trigger chain for processing these tasks which has custom query jobs and W...
We have created connection for AAD, we are able to reconcile users, and we are also able to recon groups as well, however we do not see the user's AADGroup associated to the account.
Hi,This is with reference to Custom Query that will be deprecated in 23.9 version. We have a situation where in we need to use the below mentioned query under Enhanced Query as there is a restriction of Users table.O365 is not a not added as Birthri...
Hi,We are on version 23.8.Can someone please help me write an enhanced query to update the usernames in lowercase. I try below but it din work:SELECT LOWER(USERNAME) AS USERS__USERKEY ,u.userkey as USERS__PRIMARYKEYFROM USERS u;ThanksNidhi
Hi,I've searched the docs and forums and have not found where the "To:" email for the "...(ApplicationDataImportJob) has been blocked and skipped" notifications is set. I am receiving this notification to my email, and the "From:" address is the one ...
Hi,We have a requirement to build a custom JAR for a use case. The JAR needs to execute a query against a remote Oracle DB and retrieve the result of the query. In order to execute the query on the Oracle DB from the JAR, we have added ojdbc8.jar dri...
Hello Team,We are upgrading from v5.5SP3 to v23.11, Since custom query job is deprecated do we need to convert all existing custom queries to Enhanced query execution job.ThanksDeven Karande
Hello,I would like to update ae1.startdate to null through Enhanced query like below but there's a restriction by datatype, it returns error.Can you please give me any advice ?SELECT NULL AS ACCOUNT_ENTITLEMENTS1__STARTDATE, ae1.accentkey as ACCOUNT_...
Hello, We are onboarding the NetSuite application via the SOAP connector and the connection has been successful using the below connection JSON. however, while running the jobs, the jobs are getting failed and error mentioned below. Kindly guide on h...
Hi Team,Recently our saviynt account import job(DB connection) failed with some duplicate entry error. On checking the issue, we did not find any duplicate entry. There were some timebound roles assigned to users, when the job failed it deleted all t...
Hi Team,We have erased identities in Saviynt (we are erasing through analytics job) and the SaviyntForSaviynt account status is Manually Suspended for these erased identities.Can we configure a recon/account import job for SaviyntForSaviynt endpoint ...
Hi Team, Could you help on below Query design for EH Custom Query: updateentitlement_ownersinner join entitlement_values on entitlement_owners.ENTITLEMENT_VALUEKEY = entitlement_values.ENTITLEMENT_VALUEKEYand entitlement_values.ENTITLEMENTTYPEKEY = 2...
Hi,Getting following error on updating NULL value using Enhanced query execution job.Query:select concat(Name,'-Removed',' ','on-',CURRENT_TIMESTAMP) AS accounts__name,'SUSPENDED FROM IMPORT SERVICE' as accounts__status,NULL as accounts__REFERENCED_A...
Hi All, We have integrated Saviynt with one of the LDAP Application, full account import usually takes around 45 mins. Once the job runs, after 6 mins the target application went down but the import job ran for 45 mins and job also completed with suc...
Hi All,We have one use case when User Identity will create in Source of Truth then Source of Truth will send notification To Saviynt based on that notification user import job need to be run automatically after receiving notification . Here the sou...
Hi Team,For Enhanced Query when we execute the query if data not available based condition based it got failed out due null update.Can you provide solution ?Ex:SELECT '3' AS ARSTASKS__STATUS,A.TASKKEY AS ARSTASKS__PRIMARYKEY FROM ARSTASKS A WHERE A.E...
Hi,Current Version: 23.10We have 300 entitlements for endpoint1 and we have a custom query job which adds mapped entitlements of endpoint2 to endpoint1 entitlements but now the configuration has changed. Now we need to remove the specific query insid...
I am trying to create a mechanism to automatically make the Role status Inactive over a period of time by following these steps:① Add "-old" to the end of the Role Name of the Role with "FY 2311" in the Role Description.② Make the status of the Role ...
Attempting to use the new Enhanced Query Execution which appears to just hide doing inserts and updates by disguising them as select statements within the logs. I keep receiving a syntax error when I preview (which then results in the window closing ...
Hello everyone,We require assistance in resolving an issue. Can you offer any guidance? We have an Update User Rule that verifies whether the enddate attribute is less than or equal to the current date. If so, we will deactivate the account in the fi...
