and more in a single search tool across platforms. Read the announcement here. |
I've been trying to use CTE (Common Table expression) as part of our Analytics. However this forum post indicates it wasn't supported as of 24.1 I'm just wondering if this has been implemented as of 24.5 as we're seeing a similar error or if it's d...
Hi,We have the following scenario:John Doe has two active directory accounts JD1 (Main Account on the main AD connection and endpoint) and JD2 (Secondary Account on a different AD connection and endpoint).Both of the accounts should have access to th...
I have a custom report that I am trying to export in a CSV. When I export it tells me a background process is running and email will be sent when its done. I received the email but do not see where the CSV file is stored. Where does Saviynt store the...
Hi,Unable to run v2 runtime analytics from analytics history pager from custom sav role, but able to run v1 runtime.Getting access denied error. The below feature access has been added in custom sav role.
Hello,My requirement is to create analytics to pull all user having role assigned but entitlements of that role is not mapped to account.i tried below query but Saviynt is not allowing me to create, no error message, i am able to preview. when clieck...
We are using the following algortihm in coarse match :(t1.preferedfirstname=t2.preferedfirstname or (t1.preferedfirstname is null and t2.preferedfirstname is null)) and (t1.lastname=t2.lastname or (t1.lastname is null and t2.lastname is null)) and t1...
Hello,We are getting 400 bad request. Localauthenabled set to true for the user we are using and the sav role admin assigned. Can someone help me what I am missing here.
We have created the custom Sav role "ROLE_CPAM_REPORTS" where the users should access a couple of analytics and not all analytics.I have given the feature access, Web Service access and Analytics as per below screen shots.When user is assigned with S...
Hi,I wanted to know with regards to the UNIX Connector. In case there are 500 servers, do we need to onboard all of them as as a separate application, or there is some kind of a central server that holds all the individual servers which can be onboar...
Hi Experts,In one of my dashboard configurations, I added the Global JSON Query config, and I also set it at Global Configuration => Analytics => Application Global Filter. I selected Endpoint.But I don't see the filter on the Dashboard page I tried ...
Hello,In our current environment, our Saviynt instance pulls its users from 2 sources of record, one for contractors and one for employees. As part of their roles, some contractors require access to the SOR for employees and are included in the user ...
Hi Team,We are working on some analytical controls to identify out of band accesses within EIC and for this would like to use the baseline feature of Saviynt. Has anyone of you worked on baselining before?1) Do we need to be aware of any known issues...
Hi. I have the following userImport Config:{"connection": "userAuth","successResponses": {"statusCode": [200,201,202,203,204,205]},"url": "https://removed-dev.saviyntcloud.com/ECM/api/v5/fetchRuntimeControlsData","httpParams": "{\"analyticsname\": \"...
Hi I have a need to check the last logon value on an account's CustomProperty that has a date value stored as a unix timestamp and if its greater than 60 days in the past, disable the associated account. I believe this is possible leveraging actionab...
We are attempting to create a technical rule that should only trigger if the user doesn't already have an entitlement on their AD account, but are running in issues with the query. We have tried creating the query both inline and using joins, but sti...
Hello All, I want to create a report for application owner campaign having 1) Campaign Name2) ConsulteeSuch that the step2 consulted is done but there is no response. Kindly guide me as I am not aware of which table the actions get logged like consul...
Basic Approval Flow in system :If User is termed and if that termed user owns any entitlements, system will assign those entitlements to his manager.Edge Case that we are discussing now is,If user and his manager are termed on the same day the system...
Hi Team,Can you please help me on the below request 1.In control center module can we add any other custom reports as KPI other than the default analytical reports given in this module ?if adding custom reports is feasible to add as KPI's can we chan...
Hello Folks, In our Certification table, we are able to view the flag (0 or 1) if a reminder email has been sent.However, if I need a report with Reminder Emails that were sent as first, second, third, fourth and fifth reminders from in progress camp...
Hi All,Is there any possibility as out of box configurations from saviynt side to generate report in csv format and share it over email?We have requirement to share report over email but as default saviynt send it as .xlxs format. But customer is loo...
Hi, I am using fetchRuntimeControlsDataV2 to obtain the logs. When we hit the URL from postman, be get error 'Runtime v2 analytics not found'. The analytics is v2 and is working fine. I also see '412 Preconditions Failed' message in postman. NOTE...
Hi,we import accounts from SAP and those accounts will get an integer value for APPLICENSETYPE, for example 4.When we view that account in Saviynt, the text field for App License Type displays "SAP E11 Test" instead of the value 4 that is in the data...
Hello,We are getting error when we try to send emails to managers about their subordinates through analyticsbelow query iam usingSELECTmgr.username AS username,mgr.firstname as 'ManagerFirstName',mgr.email AS ManagerEmail,usr.username AS UserUsername...
Hello Team, We are getting a 403 Forbidden error while trying to create SFTP Connection type while setting Enhanced Connector Framework to "true". Any idea why? Please see the error below. Any help would be appreciated. Thanks
Hi team,I configured Duplicate identity management job and after running it is throwing below error.Below is the config changes I did in global configuration to enable duplicate identity management in Saviynt.Error after running job --2024-04-24T15:1...
Hi everyone,We have a requirement to create a new runtime analytics report. We have developed the query, but now when we are creating as new runtime analytics it's not getting created and not showing any error in UI and logs.Thanks,Abhinav
Hello all,So we have a few Dashboards scheduled in our project which are report based and runs once a day, that's when the data is being refreshed. All the Dashboards are ES tile based. Now we have a requirement to update the data more frequently so ...
Hi Everyone,We are trying to set enddate of users to a static value such as "31/12/2025" for some users.We tried with the following query "UPDATE USERS SET enddate = DATE_FORMAT(STR_TO_DATE(31/12/2025, '%d/%m/%Y'),'%m/%d/%Y') where enddate is null or...
What is the query to get Parent entitlement and its child entitlements
Scenario : We have a set of endpoints with logical (user friendly) entitlements - they represent application roles.Users can request them via ACR process. We have hundreds of them. To map these user friendly entitlements to "real" entitlements impor...
We have a requirement to pull all the jobs that ran in last 24 hours with the average time from last 15 daysI have the below query to pull thatSelect t1.Jobname, t2.run_time as last_run_duration, t1.average as 15days_Avg_run_timefrom(Selectj2.JOBNAME...
Hi Team,We have a requirement where we need to compare time in the CST Time zone. We tried to use the function CONVERT_TZ(sysdate(), 'UTC', 'America/Chicago') but Saviynt is not returning any values for the function. We have used below query to try t...
Hello,i want to send an email to every manager listing his employees having a contact end date in 30 days.This email aims to provide a list of employees with contact end dates approaching within the next 30 days.Below the analytics i did :Can anyone ...
Hi guys,I want to clear specific customproperty of users if customproperty is "Not Null".Is there any way to clear user who's specific customproperty is not null by Actionable report?I can't find actionable option on report for update user's custompr...
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,...
Hi Team, I need to create an analytics report by fetching the user details of the user for whom a particular campaign has been launched..Can someone please help me with the suitable analytics query.
Hello all,I have workday source of truth. i am only reading from workday (it is a one way connection). I have imported all the users for now.I want to place a detection on newly imported users to detect the duplicates and block the user creation unti...
Hi Team,Is there is any possibility to truncate the line or fix the char (get 1000 char only) In below query Can set the limit to 1000 characters only to PROVISIONINGCOMMENTS.SELECT DISTINCT tasks.TASKKEY,tasks.PROVISIONINGCOMMENTS FROM ARSTASKS ta...
Hello, I am using the below SQL to query some data and I'm getting an error when I run it. Query: SELECT curdate() as 'Date', a.endpointkey AS 'Endpoint Key', e.endpointname AS 'Endpoint Name', a.accountkey AS 'Account Key', CASE WHEN a.endpointkey =...
Hi,Can we store user certificates in saviynt and use them while provisioning to connected target systems? or is there any alternative? Best regardsHarish
Hello,we have an SQL query which is running fine in analytics and now we try to rephrase this query, which was provided by the Saviynt PPS team during project implementation.If we just copy the query from working report definition to data analyzer, t...
Hello, I'm looking into the archiving capabilities related to various intelligence queries we've created. 1. Just to confirm, to archive results older than the "Number of History to Keep" parameter, we just have to enable archival in the configuratio...
Hello,I need info of prerequisites for performing role mining.1) Any Additional license required?2) Any Global config changes to be made?3) Any updates/option to be enabled in externalconfig.properties Thank you.
Hi Everyone,Our requirement is to send analytic report via email to an specific email id. We have created an analytics with the below configuration. The Email notifications are also sent but the issue is the notifications are sent only when i add ${u...
Hello,We are trying to figure out the best strategy to use for role mismatch scenarios. I read on documentation and forums about using Saviynt analytics to capture users with roles which are missing entitlements. Also using the analytics as actionabl...
Hi Saviynt, I am trying to export some data using the data analyzer but my SQL query is getting capped at 100 results. Is there a way to get around this cap so I can export the full results of the query rather than the 100 top results?Thanks in advan...
We are running 23.10 and having issues trying to use variables from analytics in an email template.Originally we had an analytics running to disable unused accounts after 30 days and the email would go to the user for that. This worked in 5.5.Accord...
Hello, I'm attempting to find any entitlements associated to endpoints in IGA that do not have an entitlements mapping record associated to them.Essentially meaning the entitlements do not have an active directory group mapped to them to be granted. ...
Hi.Is there any way to pull out all the analytics reports with query details by SQL query? (Or any way)I was wanting to know how many reports have dependencies on specific customproperty since I was trying to change the usage of the field. Also, conf...
Hi Team, I've created the analytic record and created the siem-sid user with the required permissions as per the documentation.https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter20-EIC-Integrations/Saviynt-...I am able to see the...
