|
Click HERE to see how Saviynt Intelligence is transforming the industry. 
|
Hi, I am trying to create a SOD report which will identify all the SODs occured in last 30 days. Along with it, to add all the function names and entitlement value associated with it. Upon joining the other function key, it is throwing an error, and ...
Can third party application perform SFTP into Saviynt to pull the files generated by Analytics. We have a requirement where the customer does not prefer Saviynt to send the analytics reports to their SFTP server by using OOTB SFTP connector.They woul...
Hello,Is there a way to view all the one-click disable initiated terminations? Basically, how can we see/report on all of these actions and see who submitted them, when etc. Do we need to create analytics for this?
We need to update the customproperty of entitlement value 2 with Entitlement_type 2 with the value of entitlement value 1 entitlement_type 1 , We have written an Advanced Query for that. Its not working. Can you please help us on this ??select e.ENT...
Hello,i am trying to assign owners to entitlements using analytics + sav4sav connector.in runtime analytics analytics i have the following: and it is working as expected:SpoilerSELECTev.ENTITLEMENT_VALUE AS entitlement,REPLACE(ev.CUSTOMPROPERTY3, ',C...
I am trying to test an email template being sent from an analytic. The first test came through. Then I made some small changes like removing some of the fields from the report and re-ran. Didn't receive anything. Adjusted a parameter in the query ...
When I try to access the Users table in Data Analyzer, I get an “Error : SELECT command denied to user~~for table ‘users’” and cannot access it.Please troubleshoot this problem.
I have written a sql query to get all the requests and their details along with the business justification but the issue is it is coming with html tag and is not readable. I tried using replace function which is working but it is not allowing the n...
I have a requirement to generate an all identites analytic report that can also show the first enterprise role assigned to them, total number of enterprise roles and total number of roles that a user has in a report with other columns.Below is my cur...
Hi,Since we are using an sql query as an action in our technical rules to apply birthrights to users in our environment, we are not 100% confident that the birthrights will be removed once the technical rule does not apply to the user anymore.This is...
Hi,We wish to send the details of all Service Account Owners while requesting new access via the Manage Service Account Tile.However, this is not working.Used the below code : ${ServiceAccountOwnerMap.get("USEROWNERS").get("ALL").collect{it.firstname...
Hi all,is there a table available in Intelligence / Analytics where we can query user changes details off the Update History pages. Thanks,
Hi, We have triggered a certification for user manager review, in the certification there are some users' application account do not have entitlement and do have base account only. Would like to ask is it possible to query base account in analytics r...
Can anyone help me in converting below sql query into an Enhanced Query?Thanks in advance. UPDATE arstasks ar,accounts acc,endpoints epSETar.PROVISIONINGCOMMENTS = CONCAT(COALESCE(ar.PROVISIONINGCOMMENTS, ''),'System closing task as account has been ...
Hello,regarding multiple entitlement owner assignment, i saw the following post:https://forums.saviynt.com/t5/identity-governance/how-to-provision-multiple-owners-for-ad-groups/m-p..."otherManagedBy": "${allOwnerList?.size() > 1 && ownerAccountListMa...
Hello,I'm starting to use analytics for the first time so there might be misunderstandings on my part.We have a usecase where we want to use analytics to provision SAV Roles through a Sav4Sav connector.It gets all users from a user group and create P...
Can someone help me in converting below sql query into an Enhanced execution query (update operation)1) update accounts set status='SUSPENDED FROM IMPORT SERVICE' where endpointkey=12 and name like '%on-%' and status in ('2','Manually Suspended');2)...
Hi, When i am trying to run the below query it is returning the result in Data Analyzer and Dry run in analytics. But it is throwing the error "Alert: Control execution is taking longer than expected. You will be notified when the result is ready." ...
Can we create custom Dashboard using analytics? as we have out of the box analytics charts We are doing manual monitoring manually for example how many users got onboarded and how many terminations happened today ?client wants GUI representation , pl...
Email notification is not working, it used to work not sure what causing the issue, below is the email body and using binding variable ${userEmail} to send email to manager, A new vendor has been created<table><tr><th>VendorUsername</th><th>First Nam...
I need to Update Statuskey. Email and Displayname and some other fields for UsersCurrently updates are done in the backend or through import sheet. Update process needs to be automated with Actionable reports and it should be done from the applicatio...
Is there a way to trigger update account task for an endpoint based on the value of the customproperty of an account in another endpoint in Saviynt?For example, I have an endpoint A with customproperty7 as '9/12/2024'. I need to trigger update accoun...
We currently have a scheduled job that runs an analytics report weekly. We then have an SFTP job that puts the exported report on a shared folder. However, the name of the file is causing an issue. An example is...CassVF_HKey5ca4fafe632442bc9e68ab...
Hello Team,Is there a way for the Provision Access actionable analytics to create provisioning tasks each time the analytic is run for tasks that error?We are currently testing something regarding accounts and access, but our analytic only tries prov...
When i have the filter of the username="" set it works, but when i try to run the analytics without it"basically so it is applied to everything not only 1 user" it doesn't work in data analyzer: "even when i tried to limit it to 10" and when i try t...
Hi,we are trying to create a SAV Role that allows its users to view usage analytics. (Intelligence -> Usage Analytics).We added the following feature to the SAV Role: Usage AnalyticsA user having this role can now go to the menu Intelligence -> Usage...
Hi Team,We have an requirement to extract the List of All the Requests which are pending with Admin(user).Below Query is perfectly working fine if the Request is pending with only Admin User( I mean for request only one approver is there which is Adm...
Hi Team,We are using below query to get a report of users that are updated on current day. Select u.username,u.customproperty14,customproperty20.........from users u, usershistory uh, USER_ACCOUNTS UA, ACCOUNTS A, ENDPOINTS Ewhere(CAST(uh.updatedate...
Hi Saviynt Community,as a follow up on this topic i would like to ask, the long Query execution would be worse once we are in the production and have more than 100 thousands entitlements to assign right? so..I'm currently exploring a solution to dyna...
Hi all,We are facing the below issue related to Email trigger and resolving binding variables- Email Binding Variables not getting resolved: Receiving Email Notification mapped at Endpoint level but binding variables are not resolved.Sample Email tem...
SELECT u.displayname AS 'Employee_Name', uh.updatedate AS 'Updated_ON', r.displayname AS 'Role_Owned', ev.entitlement_value AS 'Entitlement_Owned', CASE WHEN r.displayname IS NOT NULL THEN 'Role_Owner' ELSE 'Not_Role_Owner' END AS RoleOwnershipStatus...
Hi Team,We have to create analytics to findUsers having Manager, Manager having AD account(not users account) show as Yes else NO and Manager's employeeid.for a particular endpoint(endpointname="XYZ")Required columns: username, user employeeid, manag...
Hello all, is it possible to send a separate email to the ticketing everytime an analytics generates a user's report?For a context, we have analytics that generates the user's new account creation and add access, and it is scheduled for every 1 hour...
Hi,I have created a job for executing actionable analytics from job control panel. The analytics is also sending email notification about the accesses being removed through that analytics.The job executes the Default action for analytics and creates ...
Hi, we have few reports scheduled by job. and last week we migrated to new version EIC. we found few reports did not run post EIC. now we want to run a query to identify all the report those are scheduled by job but failed to run. please note: we hav...
Hi All,We have a requirement to update account owners automatically through Analytics. So we are calling runtime analytics from sav4sav and in call 2 we are updating the account owners.We have prepared the below json and used in ImportAccountEntJSON....
SELECT u.owner as ManagerEmail, CONCAT(u.Firstname, ' ', u.Lastname) AS DISPLAYNAME, u.email AS ConsultantEmail, u.EMPLOYEEID AS EmployeeNumber, u.CUSTOMPROPERTY12 AS EmployeeStatus, CASE WHEN u.STATUSKEY = 1 THEN 'Active' ELSE 'Inactive' END AS Stat...
Hi Team,Requirement is to create custom query that will fetch the role name, the associated entitlements mapped to the role, and the accounts mapped to those entitlements for a particular endpoint.Can anyone please help me on this to create custom qu...
HelloI need to provision an AD entitlement to the newly created service account that meets the below criteria. How can I do it using the Analytics? Where do I specify the entitlement that I need to provision?select e.endpointname, a.name, a.custompro...
Is there a way that a report can be generated and emailed even if there are 0 records?We have a compliance requirement to generate a report even when the count of SOD violations is zero.
We have to create an analytics report for User with email but no AD Account or users has Alpha username without email and no AD Account (for endpointname=XYZ)
We had a scenario where the internal SaviyntforSaviynt accounts were still active for handful users after termination. I was able to pull their records using/cloning the OOTB analytics "Inactive users with Active Accounts". I was trying to take an ac...
Hi Folks,After upgrading to EIC 24.7 from Saviynt 5.5, we noticed that the historical analytics data has been disappeared from the run history and is showing a count zero. Before the upgrade, we were able to see the counts in the history. Did we miss...
Objective: The goal of this use case is to create a hardcoded password in Saviynt, assign it to an attribute, and propagate this password to both an external application and downstream applications within the Saviynt ecosystem. This ensures consisten...
I am trying to return analytics details using fetchControlDetailsES with over 500 rows, but it appears to be limited to 500. I have found various forum posts also stating this. One says to use pagination, but it does not seem to work for me. It then ...
We have an analytics query to notify users if SSL certificate is due for renewalBelow is the one that is already setselect DISTINCT ss.alias, ss.valid_to, '' as connectionname from users u, sav_sslcert ss, externalconnection ec where userkey in (sele...
Hi Team,We are creating a runtime analytics where between startdate and enddate we were fetching task details.however I was not able to fetch the Time format in the runtime analytics configuration while previewing it.the below query is fetching the d...
Hi there, I'm utilizing the external jar to login (service account in use), fetch details from the analytics after running and send email based its information, but am getting this error,Exception while validating connection!: connnection proxy not u...
Hi team,I have two dynamic attribute DA1 and DA2 on the request form, for service account. Is it possible to store the concatination of these two attributes in a single account customproperty?Thanks.
Hello all,I wanted to see if someone could assist with some dashboard questions I have so that I can get a better understanding of the feature. I've gone through the documentation and tested a few queries just to get better feeling of how the dashboa...
