and more in a single search tool across platforms. Read the announcement here. |
Hi,I am creating an analytics where we are trying to get a user and their accounts of a certain endpoint. On top of that, we are also trying to get the entitlements of those accounts. The endpoint has two entitlement types for every account, "Profile...
Hi Team,I'm trying to retrieve records from External DB for which i created a connection with external db details and the connection was successful.Now i'm trying to create an analytic report by giving above created new connection in External Connect...
Hello, is it possible to use an "in" instead of "=" in a SQL query where you provide a dynamic attribute for users to populate when running the report?Essentially trying to get entitlement history for a user (currently), but would like to allow users...
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...
Hello Team,We have a requirement to fetch the complete duration of access approval process (duration from request creation to access assignment ) for a particular endpoint.If someone has a query or a reference article please share.
We are trying to create an audit log report and export the results in Excel.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 '...
Hi Team,Can you suggest approach to send notification after completion of tasks, not from global configuration and end-point level. Is there any option to send from report then please share the sample query and how to trigger notification and have to...
Hello Team,Could you please help with Analytics query for below.User-onboarding email notification to Manager with User Account and Random password details. (whose startDate=5days)AD account password expiry notification whose password is going to exp...
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...
Hello Team,Requirement:New User (From HR ) will be created in Saviynt and in AD as birthright is enabled, but account will be in disabled state till the startDate reached, on the startDate the account should be in enable state. Email notification sho...
Which configuration allows to return all 10k records from runtime analytics v2 API.Currently its returning only 500 records Thanks
Hello,I was getting activity logs by the SQL below but found It won't be including request history.Is there anyway that we could get some logs of ARS in this query ? select ua.ACCESSTIME as 'Event Time',ua.TYPEOFACCESS as 'Object Type',ua.ActionType ...
Hi Team, As part of platform optimization, we have started reports clean up activity, a bunch of them are control center reports which are created automatically.Can you please confirm if it would yield any benefit for us in deleting them as they are ...
Hello,tried to run an AnalyticsJob to delete users who were imported via specific Job IDs.I wrote a query like:SELECT userKey, PIIERASURESTATUS, 'personallyIdentifiableInformationErasure' as Default_Action_For_Analytics FROM users WHERE JOB_ID IN ('1...
Hey Folks,Is there any feature/setting for analytics to delete previous generated files? Issue is we are utilizing SFTP JarConnector to send files to target server, and the connector is sending multiple files from old dates aswell,So if there is any ...
Hi. I have created several run time analytics. When running them through the /ECM/analyticsConfig/runtimeanalytics on screen, they work and produces the output which is desired. They are not preventative.This is the analytics SQL (which btw should no...
Hi,We have a requirement to create a SAV Role in Saviynt v23.8, so that its members can access the Analytics module to strictly perform only the following tasks:-1) View & Download V2 Analytics Reports History.2) Run only the Custom Analytics Reports...
Hi All,We have an application where Account's access should have End Date. So End Date has been made mandatory in Saviynt Form. Once EndDate is set then it is visible in Saviynt GUI >> Application's Account >> Associated Entitlement >> Access Name 1 ...
Hi Team, We have created analytic control with Provision Access as action. We are triggering the analytic control from Job with execute default action checked but add access task is not getting triggered.From Run history also, we are not able to tri...
Hi everyone,We are currently in a pre-production phase and just recently imported existing AD Accounts to Saviynt.To align our current accounts with our goal definition of an AD account we need to add some Information to the AD accounts, that are pre...
Using the allowed action set as "Map orphan account" allows the user to manually map the orphan account to the correct user identity and it also leaves the audit trail to follow it that who performed the operation and at what time.Issue: Once you aga...
Hi Team,Could you please help or guide us with the below analytics query? The use case is when the user is onboarded into Saviynt. Then, when user gets its region , the particular region group should assigned accordingly I have written a query in th...
Hello,I am trying to extend the end date for the enterprise role. I am able to update the new end date, but the role removal is still getting triggered after the old end date has been met, even though the end date has now been updated.Below Image sho...
Hi Team,We are using Saviynt v 5.5 SP 3.20 version.We are storing user's division value in customproperty2. There is a requirement to generate a report on monthly basis whose custompropery2 is changed.Can anyone please guide how to achieve this.Thank...
Hi,We have a use case where we do not want to send repetitive data in the consecutive scheduled analytics report emails.I came across "Base Count" feature which promised to solve the exact case.But unfortunately, it does not seem to be working for me...
How do I create analytic reports which could have records more than 10000 records?Currently I get this following error message.
Hi All,In global configuration, after enabling the feature of "group emails by username" for analytic reports. This is working as expected to group emails by username but found few observation as below:Usecase:Sending Delegation expiry Notification t...
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...
Hi Team,We have two applications (A and B) with their own endpoints. If application A has one entitlement value, ABC, based on this value, we need to frame one new dynamic entitlement value, like ABC_01, for application B.We have tried in analytics t...
Hello everyone,I have strange issue with trying to create to analytics.I am actually trying to copy the existing analytic that we have for all Endpoints and create a new analytics for two new Endpoints. What is strange is that I get an error saying ...
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 all, My requirement is get the date of user's role change. We need a report which contains the list of users whose role was updated in a particular period. What query can be written to get above data?
Hi Team,could you please help or guide us with the blow analytics query? the use case is that. there is one attribute in Netsuite is CP23. If CP23 is true and NetSuite Account status is true then add okta group to user's OKTA accountNetSuite Endpoint...
Hello,We have task to provisioning entitlements to the accounts for specific endpoint through analytics query i used different method to do it but unable to find solution. can you guide me on how to solve this.
Hello everyone,We´re trying to call the fetchRuntimeControlsDataV2 module from the Saviynt API, just as in this post: fetchRuntimeControlsData Saviynt API, is returning... - Saviynt Forums - 11837, but all that we´re getting back from the call is the...
Hi Team,We need to fetch the username who created the Analytics Report. Can you please help with the Cloumn name to fetch the details?Regards,Imran Syed
Hi Team,We need below attributes or columns to be fetched for the analytics report.1 Report Schedule2 Last Modified Date3 Last Modified UserIs there a table that I can refer to extract? Regards,Imran Syed
Data in location field on a user is displayed as "USCA > USA > California > San Jose 190 - TBL" when looking at user attribute on the user.When using Data Analyzer or report it displays as "USCA > USA > California > San Jose 190 - TBL"I hav...
We've added all the SAP licenses types into the license manager an it shows under BEFORE CLASSIFICATION the right amount of licenses but after running the license analytics it shows under AFTER CLASSIFICATION only for one license typ the same amount ...
Hi Team , In Salesforce application there is one entitlementtype i.e. PROFILE and entitlements of which cannot be removed( Service account does not have the access). So we need to check if an account is not having any entitlements other than entitlem...
We have 'Deprovision Role' as allowed action in Analytics controls; similarly, do we have 'Provision Role'?In the below documentation, we have 'Deprovision Role' but not 'Provision Role''Deprovision Role' as 'Default_Action_For_Analytics'https://docs...
We need to detective the list of users who do not have an Azure AD account.The Azure AD endpointkey is 4.What query can I write to detective the user?
Hi Team,We would like to understand what this option does really in the RunAnalyticsjob? We tried in the documention portal but not nothing much .
Hello,I need an extract that is pulling Identities which have manager gap between the ID and the account :i select the username and his accountID and some values of the account (the manager (DN of the AD account for this identity)theni pick the up t...
We have a requirement to provide read only access to few features of Admin module(viewing accounts, access, etc) and simultaneously they should also be having access to manage the analytics. I have attached the features that we have added in both the...
Hi - is there a way to generate a report of users having localauthenabled=1 in Saviynt?I tried running a query in Data analyzer but its not permitted.
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 Team,As part of platform optimization, we are trying to optimize the reports performance by tuning them. Is there a way to identify the top 20 reports that is long running and consuming more resources or memory?Any inputs or suggestions on analyti...
Hi All, We are trying to generate an anlytics report where customproperty4 of entitlements has the values as below example:CP4 = server1;server2;server3;server4;server5;server6 (It can contain more than 100 values separated by semi colon)Below is the...
