Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/12/2024 03:37 PM
Hello team,
I have following mapping for getting lastlogondate in CP21 as
CUSTOMPROPERTY21::lastLogon#millisec,
I want to change the value to "mm-dd-yyyy HH:MM:SS"
Thanks
Mahesh
06/12/2024 09:32 PM
06/13/2024 06:01 AM
06/13/2024 06:07 AM
Hi @mbh_it1 ,
Can you try something like below and check once. It's working for use for user import but not sure for account import
CUSTOMPROPERTY21::lastlogon#Winepoch-customDate
06/14/2024 07:27 AM
06/15/2024 10:07 PM
SELECT
DATE_FORMAT(a.customproperty21, '%m-%d-%Y %H:%i:%s') AS accounts__customproperty22,
acccountkey as accounts__primarykey
FROM
accounts a where endpointkey=1 and status=1;