Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/21/2024 11:41 PM
Hi,
I am having issues with the LASTLOGONDATE within my csv file. I have tried a number of date and time formats in the CSV but none seem to update the LASTLOGONDATE of the account inserted or updated as part of the schema job. All other updates work ok. Example
accountname,endpointname,status,displayname,lastlogondate,customproperty31,role-adhoc-searchhead
xx@abc.com,splunk,1,Blogs Joe,03-Oct-2024 02:20:54,xx@abc.com,corp
Any ideas?
Solved! Go to Solution.
10/22/2024 06:36 AM
Did you checked logs
10/22/2024 01:16 PM
Please check on the logs and also try this
'2024-03-01 08:31:00'
10/22/2024 02:22 PM
That format did not work, see above reply, thanks
10/22/2024 02:21 PM
I'm only seeing this with no mention of lastlogondate found in sav file
10/22/2024 02:59 PM
Share your sav file
10/22/2024 03:00 PM
Not sure how Saviynt developers expect users to make the correct mapping here when the accounts table clearly says LASTLOGONDATE :).
As lastlogondate was not detected in logs I tried comments instead and it populated the data. I then tried (pure guess)
accountname,endpointname,status,displayname,lastlogindate,customproperty31,role-adhoc-searchhead
Saviynt detected lastlogin in logs and populated the LASTLOGONDATE which displayed in SAV gui/portal for the accounts.
I then changed to
accountname,endpointname,status,displayname,lastlogin,customproperty31,role-adhoc-searchhead
and that also worked.
10/22/2024 03:02 PM
So lastlogin is working ?
10/22/2024 03:03 PM
Correct, it is now populating with the correct date however time is 00:00:00.
10/22/2024 03:18 PM
What is working date format
10/22/2024 03:24 PM
As example 11-Oct-2024 02:20:54 is working for the date but time is imported as 00:00:00
10/22/2024 08:28 PM
Hi @Huddos Below is working format 2024-10-11 02:20:54
I have validated this
Also below are columns supported
10/22/2024 09:11 PM
Awesome, that date/time format is working for my instance also. Thanks for validating and confirming supported columns.