and more in a single search tool across platforms. Read the announcement here. |
I'm looking for a way to create an analytics report that contains request ID, Request Type, Submit Date, End Date, Requestor, Requested For, Assignee, End Points, Request Details and Business Justification. Thanks!
I'm looking to develop a report that shows the privileges assigned to all users and how they were assigned. Specifically, I'd like to know if the privileges were assigned via a role or through other methods like birthright or ad hoc access requests. ...
I'm looking to develop a report that compares two identities and shows the list of missing entitlements from Identity #2 when compared with Identity #1. Do you have any insights or suggestions on how I could go about creating this report? Thank you.
Hi All,We have actionable analytics that is used for tracking if user has completed a review or not.We have Accept and reject in Allowed actions.Currently it is sending out email to users even if all items are in accepted state.Is there a way to only...
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...
We would like to design a Runtime Analytics report to query the Transport Details of previous Import requests. Specifically we would like to know which objects failed on a successful import. Is there a database table where we can find the information...
Query to extract an application add access tasks, user name details, request details, security system ,end point details, approver details.
Even though I have set the default action for analytics as 'Update Account'. The action for analytics always shows up as 'Open'. What could be the reason?
Hi There,I have below query which is giving a result for the revoke access present in the system and are expired since 30 days----------------------------select * from (selectDISTINCT (SELECT DISTINCTSUBSTR(ar.jbpmprocessinstanceid,INSTR(ar.jbpmproce...
Hi Everyone,Please help me in adding REQUESTORIGIN Column in the query. When i was trying it was throwing unknown column error.Thanks.
Is there a way to configure the email template for an Analytic so that the output is sent to the user that kicked off the request?I see references to ${USER} in the documentation but that doesn't appear to be available in this situation.
Hello Team,We have a requirement where , we need to launch a User Manager Campaign, so when the manger clicks on "Does not belongs to me " then an user update task should trigger.This can be achievable from Sav4Sav Rest connector.Did anyone worked on...
Hi, I have copied the default Analytics Dormant Accounts - Active Directory and set up an analytics job with the below query:SELECT u.username AS 'Username', u.jobcodedesc AS 'Position Title', u.customproperty15 AS 'customproperty15', a.accounttype A...
Hi Team,We have prepared one campaign analytics when we do a dry run then it shows expected records but when we do run now it does not show any records and also it is taking more execution time to run but In the data analyzer we can see expected reco...
Hi,Iam trying to enable the account via analytics, when start date & current date have 1 day difference.Query:select u.username,a.accountkey acctKey,'enableAccount' as Default_Action_For_Analytics FROM USERS U, USER_ACCOUNTS UA, ACCOUNTS A, ENDPOINTS...
Hello, I am using LASTLOGONDATE > CURDATE() - 30 in the account query for the user manager campaign to certify accounts. However, after launching the certification, it reports 0 records, even though we have existing accounts. Thanks,Deepu
Report to extract the owners, owner status of Active, requestable Enterprise rolesPlease provide query extract the owners, owner status of Enterprise roles with Enterprise roles status , requestable status.
let say we have one sample technical rule "Test_Assign_finance_global" from which er are providing the access finanace_global group.I want to run query that will produce the name of user update rules those are triggering this given user technical rul...
Hello,I want to know the work of"Create New Controls request" function on Analytics History.On Analytics History page, click Actions > Create New Controls request.And "Send an Email to us" window is displayed as follows.About this function, admin gui...
Current Scenario: We have created an actionable report with an allowed action set as "Accept" for application owners to accept the risk of the account being an orphan in Saviynt.Ask: We want to trigger the disable account task for accounts which are ...
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 Team - I am looking for an analytics query to fetch users with SAP accounts along with their assigned SAP roles, Profiles, tcode and Auth Object details. Please can someone advise how this can be pulled ? Thank you
Hello Team,Is there any way that we can query to get Provisioning Owner from endpoints ?Thanks,Harish
Hi Everyone ,We have three actionable analytics for which we have three runallanalytics jobs to run , but we want to run these three analytics jobs to run in a sequence .So , we are trying to run these jobs through trigger chain job but when we run t...
I have a requirement for which I have created an analytics and an email template for it but the challenge I am facing is :The report should trigger after each deprovisioning job runsWhat are the options to achieve this ?
Hi , I have created a analytic for extract user who is onboard with condition of start date equal current date. There is result after run the analytics task in Saviynt Portal.Just I would like to know, how to fetch the analytic result via Saviynt API...
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,Can you please let me know if we can get the timestamp present in the saviynt reports in EST instead of UTC? Regards,Sharada
Hi @rushikeshvartak , is this supported for the AD connector? I have the similar situation as this post where we are creating update account tasks using actionable analytics, however, we aren't able to update the Service Account Owner in AD. I have u...
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...
Hi we have an updateUserJSON config configured as shown here { "actions": { "Update Login": { "call": [ { "name": "Update Login", "connection": "acctAuth", ...
Analytics Report API returns data in JSON format but not in CSV. Just curious to know is there possibility with some configuration in payload or by passing query param we can get csv report when we execute API instead of JSON format data.{{URL}}/ECM/...
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...
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 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 ...
How to deploy external jar to create target db accounts, entitlements csv
Hi Team or @rushikeshvartak @Dhruv_S @Manu269 ,We are trying to create an email template for analytics which should fetch the info from analytics but that doesnt seem to be working I see below errors in the logs. can anyone help me how this can be fi...
Hi Team,We are using below query to fetch account data from different entitlements and trying use union query. Its giving error. Can anyone please check & guide what is wrong with this. select a.NAME, a.DISPLAYNAME, a.COMMENTS as 'DN', a.STATUS as '...
We have an invitation process for onboarding new external users. We can set the Invite URL Maximum Retry Count easy enough, but just how do we see how many times the user actually attempted to access the invitation?
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...
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...
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...
