Hello Team , We have imported around 8K+ records , and in secord time we have changed some logic in savfiles and these imported again 8K+ records after required transformation in Saviynt. Our query is : we need to delete previous 8K records of ident...
Hello Team , There is one scenario where i need to set users STATUSKEY=1 if ENDDATE is null or ENDDATE>SYSDATE() and 0 if otherwise.For that using this query : UPDATE NEWUSERDATA SET NEWUSERDATA.STATUSKEY = case when DATE(NEWUSERDATA.ENDDATE) is null...
Hello All , As we are creating G-suite user, can we block interactive login for this? We can see that user credentials is used to granting consent, if interactive login is required, what is the recommendation from Saviynt to have some control around ...
Hello , We have one requirement. Say we have created JML rules and want to test it . And some scenario where after 24hrs of the trigger Email will be sent or notification will be sent . Do we have any option so that we can update the Saviynt's time t...
Hello Team , We have one requirement where , a joiner entry will be onboarded into Saviynt with start date attribute say future dated. E.g. A joiner entry created in Saviynt on 1st Jan with join date on 15th Jan. We want to create the account in AD o...
We have tried this , and in the csv the start date and end date are both in YYYY-MM-DD format itself . the reason we have transformed it to make it YYYY-MM-DD HH:MM:SS is to match it with CURDATE() and btw every one of the query is running fine in AD...
Thanks just tried this, getting error as below :Error in Users Import - Error while processingdata: Data truncation: Truncated incorrect INTEGERvalue: 'Oct 12, 2021 00:00:00'The error is same just this time instead of date it's coming on INTEGER . Me...
We tried this earlier, the problem is Customproperty is of String datatype and SYSDATE() is of DATE datatype so we cannot just use Greater than or less than comparison between these 2 owing to the fact that they are of different data types. And again...
