and more in a single search tool across platforms. Read the announcement here. |
We pulled a report of the current jobs that are in Prod and we saw that they were 'Analytics_16546CRONE', 'BaselineJob_12' and 'BaselineJob_AccountImport_12343535325'. Can you please tell me what these jobs are for? and how can we tell which analytic...
Hello Team,We have use case for Enterprise Role cleanup.Details: We need to identify enterprise role which is tied to target app entitlement assigned to user identity in Saviynt but user account don't have that entitlement assigned as well as on targ...
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...
Hi Team,We have come across a use case where the customer wants to configure a functionality in Saviynt as to if in case a user is terminated, then all its access should be transferred to the user's manager for that particular endpoint.We thought of ...
We have a requirement to export all the SAP accounts with below informationAuth ObjectEntitlement associatedParent Role RoleAny assistance is appreciatedThanksMohammed Tousif
Hi Team,Can you please let me know if we can get the timestamp present in the saviynt reports in EST instead of UTC? Regards,Sharada
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...
Team - We are trying to allow an external system to fetch analytics data (Runtime and Regular) from Saviynt and we need to implement pagination within these calls because the record count is around 5K? API Regular: /ECM/api/v5/fetchControlDetailsESAP...
Hello, I am trying to find help on creating a SQL query to find all completed requests on SAP role entitlements that have text in cp6 from the past three days. The endpoint name is EP1CLNT300, and the entitlement type is saprole. Most of these saprol...
Hello Team,We are working on preparing Runtime Analytics to prepare the reportee details.Query :'SELECTu.username AS 'USERNAME',m.username AS 'MANAGER USERNAME',CASE U.STATUSKEY WHEN '0' THEN 'INACTIVE' WHEN '1' THEN 'ACTIVE' END AS 'USER STATUS',acc...
We are using below campaigns. We want to review the Saviynt data with campaign data. Can we extract with custom queries from Saviynt ?.1. user manager campaignList of all the users associated for a manager and associated accounts and entitlement acce...
Hello Team,I have created below runtime analytics in our instance.Custom - Reportee Access Details ReportSELECTu.username,u.manager as USERCONTEXT,m.username AS manager_username,CASE U.STATUSKEY WHEN '0' THEN 'INACTIVE' WHEN '1' THEN 'ACTIVE' END AS ...
Hi Team,We are trying below query to reopent the errored task in ARS through analytics. Please confirm if below query is good to proceed.select taskkey as tasks, STATUS , provisioningtries, 'reopenTasks' as 'Default_Action_For_Analytics' from arstask...
Hello Team,I have created below runtime query to fetch the request which is pending for approval based on the request ID passed as Input.We have a case where request is pending for approval and more than 1 approver name exist.Assistance Required :How...
Hi,Extracting all Entitlements with terminated users as owners regards,
Hi Team, We have a requirement where pending task gets any error,email should trigger to the requestor with error message. To perform this we have created an analytics report with basic query and configured one email template with general information...
Hello everyone!I have a report called 'ABC' where the allowed action associated with it is to disable accounts after 10 weeks (which is working). Now, I want to retrieve all these disabled accounts and deprovision their roles 2 weeks after disabling....
Hello We want to create actionable analytics report to assign 2 different entitlements. is this possible?Until now, we used Actionable Analytics to assign only one entitlement, as the entitlement value key needs to be specified in the query. If we t...
I'm trying to create a template with the provided content, but I'm encountering an error message stating, "Operation not allowed as you are entering a value that resembles or contains script code." Has anyone else encountered this issue, and if so, h...
Hello, I have the Job below that is failing now i dont't know why. I use this Job to update the status attribut for external worker.The error i get :ImportUserJSON IN Saviynt For Saviynt connexion : Anyone can help please? Regards,Ray
We have configured SFTP connector to transfer file from analytics generated to customer SFTP location.We see SFTP connector sending zip formated file to SFTP location from Saviynt analytics location after job execution successfully.But customer is ex...
Hi Team,We have an use case where the Access is added to the User_account if the condition matches.User has matched all the conditions and got the access and task is moved to Completed State and we have another analytic which will deprovision the ac...
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
Hi Team,We were trying to create a report for the dashboard which gives the Campaign progress (% of approved and % of revoked and % of no response).We have this dashboard/report in place for the User manager Campaign and we want the same for Entitlem...
Hi,I was looking under Data analyzer to get the attribute for queries that we specify under 'Advanced Campaign Configuration, but could not find any.Under 'advanced campaign configurations', we need a report that gives us the 'entitlements query', Is...
Hi,We need a query for creating analytics to get the summary of the User Manager Campaign.Regards,Naveen
Hi,I am trying to create a RUNTIME ANLAYTICS Report to pull all the tasks related to campaigns without having AD connection. I can pull all the data, however when I specify the TASKTYPE in report and while running it, we are getting alert as [Alert: ...
Hi ,We have created the Audit report using below OOTB query.select ua.TYPEOFACCESS as 'Object Type',ua.ActionType as 'Action Taken',u.username as 'Accessed By', ua.IPADDRESS as 'IP Address',ua.ACCESSTIME as 'Event Time',ua.DETAIL as 'Message' from us...
Hi Team,We have a requirement to get the list of Okta accounts that have been last logged in 45 days back for which we were able to provide the data using the below query. SELECT U.USERNAME AS 'Employee Number', U.FIRSTNAME AS 'USER FIRST NAME', U.LA...
Hi,I'm pulling all the needed revoke access tasks for an application in a report that are not processed.I want them to be processed when the default action is selected.what will be the default action to trigger those tasks for provisioning?
Hi, 1. After running an analytics report and downloading the file in CSV format, the file contains an additional character(') before phone numbers. How can we avoid this?Excel format file contains the right values(without any additional characters) 2...
Hi,I want to extract the account details of a user with no entitlement values for a particular type of entitlement for a particular endpoint. I have written an SQL code for that but I am not getting the details of the account which doesn't have that ...
Hi,I am working on a runtime Analytics which needs to pull in the list of actions taken by certifiers for a specific campaign along with the corresponding details (similar to what we see when we drill into a campaign in UI)1. Revoke > includes every...
Hi,I want to extract the details of an account which doesn't have any entitlements. I am providing entitlement_value as NULL but the query is returning no results even though there is a user with no entitlements. I am attaching the query for you refe...
When i do an export/excel of Completed or Pending Tasks from the UI a message comes up stating that " A background job has been started to generate report." An email will be sent once the report is available for download." I don't get an email. Where...
Hi Team,We are getting incorrect data for user termination date (u.termdate) for few users in the termination analytics.For eg: User "A" is terminated through campaign on 4th march, his status changes from 1 to 0. User is rehired on the same day. The...
Hi, Is there an option to provide an option for a user to view and run only one analytic report instead of providing access to view all reports in the analytic section.Regards,Sharada
Query to extract username, azure ad accname, parent entitlements , child entitlements for n number of users.
When we hit Export with in a Certification, we get a pop asking us to download a report. However the email template variables mentioned in the Saviynt Documentation do not work. same issue as poreviously mentioned in https://forums.saviynt.com/t5/ide...
I have a situation where, when a user is given birthright access via enterprise roles to a disconnected application, I need a query to trigger email notification to admin or admin groups to execute tasks. Endpoint level email template only triggers w...
Hello I am looking for an analytics query(to see pending tasks and the time taken to complete) to include in a KPI for the control center books. any help appreciated, thank you!
what is the difference between Analytics v1 , v2, actionable report
Hi All,We have a requirement where for an application we want to monitor those users who got access to entitlements outside of Saviynt i.e they did not raise a request in Saviynt but got the entitlement assigned directly in target application. Is the...
Hi,We have configured an email template for an analytics. We are trying to print the content of the analytics in the email body. For this, we had written the following in the email template:<html> <head> <meta http-equiv="Content-Type" content="t...
Hello Team,We are looking for an assistance to build a report, which provides the details as below :1. There are few requests which was assigned to admin.We are able to fetch all these request details.2. As an admin, has the capability to modify the ...
Hi ,Can we create an analytics report that has Show Consult For Own Access checked as part of campaigns that are launched or in preview state We were not able to get any information through data analyzer for this please specify if we can create a rep...
Hi,i’ve created an analytics report with default action “Disable Account”.When I run the AnalyticsV2 Job with this defAult action option Checked, it generates the “Disable Account” Tasks -> Normal behaviorWhen I select a security system in Analytics ...
I have an actionable report with action type "accept". When I click on this action, a popup appears with a choice of acceptance duration (start date and end date). Is it possible to change the default end date here?
Hi,We have a requirement to give access to Role_Auditor SAV role to run only one report. I have added that analytics in the "Analytics" tab of the SAV role. Also, I have added relevant featuers. But when I login as a user assigned to that sav role th...
We would like to build an analytics to download a full list of staff and associated accounts and entitlement. When we run, it shows the cloudflare error page. Running the same query on Data Analyzer, it returns around 650,000 records.Any method for u...
