and more in a single search tool across platforms. Read the announcement here. |
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...
Is there really no out of the box way to assign an email template to the duplicate management feature in Saviynt. So, every time a new duplicate arrives and needs handling, I would like to receive a mail.
We have an emailed report with users' start date which of course comes via Excel instead of a CSV abd it's interpreting the date as a string of irrelevant numbers. Only if I open the Excel sheet, change the cell format to Date, does it reflect the d...
Hi,We have written an SQL Query to get some details related to a Campaign(Progress, Status..etc). When we run this query in data Analyzer it runs fine and we get 4 records.But when we put this in Analytics Query we get the error:"Alert: Control execu...
How do I create analytic reports which could have records more than 10000 records?Currently I get this following error message.
I am trying to migrate V1 analytic controls to V2 but getting an error.I tried the method outlined in the form post below but I an error. Screenshot below.https://forums.saviynt.com/t5/identity-governance/analytics-v1-deprecated-from-sp3-17-how-to-co...
Hello,We are trying to clean up the list of identities pending for match and merge. In fact, we have a lot of those identities that are relics of old misconfigurations of our match and merge. Run the job "Duplicate Identity Management" do not clear t...
Hi Team, We have migrated the runtime analytics from TEST to PROD using transport but we cannot see the analytics query in PROD. We have made the required global config changes still it is not reflecting.As you can see the Analytics query is blank. ...
Hi Team,I have created a run time analytics with the following query to get user details based on the logged in userselect u.username, u.firstname, u.lastname from Users u where u.userkey = ${requestor} and also I have used the following query in "si...
Hi Team,Regarding the actionable report configured with the 'Accept' action, there are a couple of queries:1. Is there a way to hide the start and end date selection pop-up when 'Accept' is chosen as the action? If hiding the pop-up isn't possible, c...
HI Team, Here we have requirement where we need to pass runtime parameters to substitute endpoint name in an analytics job query when calling via the Saviynt REST API. Can Saviynt allows to create and execute analytic jobs with run time parameters? P...
Hi Team,We have configured an analytics report to fetch the pending requests along the assignee name with whom it is pending. We want to include the "Requested for" field in that report. Can anyone please help with the binding variable which will all...
Hi All,I know the Web Application Firewall (WAF) limit for Saviynt EIC is 5000/IP/5minutes. Is there a maximum size or number of records per request per minute for the API?Thanks in advance!
I am trying to set up an email template for analytics that includes the report name, report description, and conflict count. The analytic returns 42 rows, but it will not send the email out if I am including ${ANALYTICSDATA.size()} in the body of the...
Hi Team,Could you please confirm if to access "Duplicate Identity Management" feature under the Intelligence Module we require any additional license or payment to Saviynt. We checked in the documentation but could not find any details related to the...
Hi,We have requirement for that we need run runtime analytics api, so if I try to hit the url in postman response says job successfully started but in the saviynt I can see that it has not ran the analytics. What could be the reason? Can anyone help ...
Hello All,We're attempting to create an Analytic Dashboard on v23.6, but Tiles on dashboard will not refresh.They are Elasticsearch Analytics. Configuration is.Dashboard Query: {"analyticsConfig":"133"}Chart Properties: [{"tileType":1,"data":105,"dis...
we have a requirement where the end user should be able to see the dashboard and its report when clicked from analytics menu. but we are getting "access denied " error when the user clicked the dashboard to view its results. As admin : steps : saviyn...
I want to create a Certification from an Analytics action.This is to ask the Owner if the AD Groups I create in Saviynt are still needed one year after the creation date.Here are the steps I just tried:① Create the Analytics created by the following ...
Hello. The query below will run and send an email with the report when I run it myself. When I create a job to run the report, I do see daily history, but we aren't receiving the email. Why is that? select t.taskkey, t.taskdate as "task_date", ...
Hi Team,Can someone please help me with the query which will help me to fetch the data of users for whom a particular user update rule got triggered.
Hi Team,We have a requirement to send emails to the users with proper data in tabular form. We have configured analytics for that and attached the email template in Analytics. Once we run the Analytics or Analytics job, for every trigger it's sendin...
Hello everyone.I would like to ask you about PII elimination.I am currently trying to create Analytics and Job to erase PII but without success.When I look at Analytics History, Action is still Open, so I suspect that setting Default_Action_For_Analy...
For SOD violations, we have an user context driven actionable report which has open, Accept, Deprovision Access as action. When the user selects "Accept" with a future date(see first screenshot). Is there a way to tie that to the respective SOD Viola...
Hi Team,We have a requirement where we need to trigger User Update Rule on change of the deDuplicationStatus value of a User, i.e. once the duplicate User is rejected and deDuplicationStatus value changes from (0->2) we want to trigger the rule but u...
Hi,I need a help with a query to generate analytics/report for all features and webservice accesses for all existing sav roles and the users for each SAV roles. I don't find any tables to generate these accesses under schema. I know we can export fe...
