Click HERE to see how Saviynt Intelligence is transforming the industry. |
03/13/2024 07:43 AM
Hi Team,
We need to offboard users based on different timezones.
We are getting end date with offset value as 2024-02-15T 00:00:00 -4:00 from source but it's not consumed correctly by saviynt.
In Saviynt End date atribute is reflecting as 2024-02-15 00:00:00.0 without offset.
Any way we can achieve this? How can we make sure termination happens based on the user's timezone? Is there any configuration present in Saviynt for this?
Thanks,
Nupur
03/13/2024 09:05 PM
@Nmaheshwari refer this post :
How to Off-board Users Based on Their TimeZone? - Saviynt Forums - 11175
You can give a try by creating Sav4SAv connection
03/13/2024 10:41 PM
Store date in Customproperty and perform termination
03/13/2024 11:54 PM
Hi,
I understand that there are other workaround to use sav4sav, customproperty. Also we are already short of CPs. Wanted to check how these timezones being handled by Saviynt for global customers and if this is supported by Saviynt?
Thanks,
Nupur
03/14/2024 09:45 PM
I dont find any documentation around same.
04/03/2024 01:51 AM
To make Timezone calculation works in Saviynt version 23.10 and above . We can make a use of end date and country at user level attribute i.e whenever any user's Country is "INDIA" or anything set the enddate with + or - hours corresponds to UTC Time Zone.
Here is the related query "UPDATE NEWUSERDATA SET ENDDATE = CASE WHEN (country = 'India') THEN DATE_FORMAT(CONVERT_TZ(`ENDDATE`,'-05:300','+00:00'),'%Y-%m-%d %H:%i:%s') WHEN (country = 'Ecuador') THEN DATE_FORMAT(CONVERT_TZ(`ENDDATE`,'-05:00','+00:00'),'%Y-%m-%d %H:%i:%s') WHEN (country = 'Spain') THEN DATE_FORMAT(CONVERT_TZ(`ENDDATE`,'+01:00','+00:00'),'%Y-%m-%d %H:%i:%s') WHEN (country = 'Finland') THEN DATE_FORMAT(CONVERT_TZ(`ENDDATE`,'+02:00','+00:00'),'%Y-%m-%d %H:%i:%s') ELSE `ENDDATE` END WHERE USERNAME = 's.sapche5account'"
04/04/2024 11:58 AM
Follow solution mention here https://forums.saviynt.com/t5/identity-governance/how-do-we-handle-user-termination-in-different-tim...