Date Format for import account

[afauquem]

Hello,

I'd like to add the lastlogindate attribute (lastlogondate in Saviynt tables so i put lastlogondate as column name) when I import an account CSV file. I'm able to fill in customproperty attributes, but the default lastlogindate field won't fill in. What is the date format expected by Saviynt in the CSV file for this attribute? According to the Data Analyzer, the format would be MMM DD, YYYY hh:mm:ss but that doesn't seem to work.

[CR]

@afauquem  CSV file upload i gave below format , it working

try it

[afauquem]

It doesn't work for me. I think the problem is not related to the format.

Here's my sav file:

SystemName=Test
FileNameStartswith=Test
ENTITLEMENT_TYPE=test
DELETEACCOUNTENTITLEMENT=YES
OVERWRITE_USER_ASSIGNED=TRUE
ACCOUNT_NOT_IN_FILE_ACTION=NOACTION
ENDPOINT_NOT_AVAILABLE=NOACTION
SECURITYSYSTEM_NOT_AVAILABLE=NOACTION
ENT_TYPE_NOT_AVAILABLE=NOACTION
ENT_VAL_NOT_AVAILABLE=NOACTION
IGNOREFIRSTLINE=TRUE
FILEIMPORTDELIMETER=,
ACCOUNTNAME,endpointname,status,test,lastlogondate,comments,description

And my CSV file :

ACCOUNTNAME,endpointname,status,test,lastlogondate,comments,description
testafa,test,1,test_ent1,2/5/2024 13:13,test9,test8

In the log viewer, I see "DESCRIPTION found in SAV File". The same for the other columns endpointname, status and comments, but not for lastlogondate.
Do you have any idea what the problem is?

[CR]

@afauquem  you will get info below think so

https://forums.saviynt.com/t5/identity-governance/azuread-ootb-lastlogindate/m-p/34521

https://forums.saviynt.com/t5/identity-governance/entitlements-aren-t-getting-mapped-to-accounts-in-...

[rushikeshvartak]

Refer 

https://forums.saviynt.com/t5/identity-governance/entitlement-mapping-of-different-entitlement-types...

[Manu269]

Few issues i can see :

1. FileNameStartswith please add the extension also .csv

2. Verify the ENTITLEMENT_TYPE attribute. Navigate to EP and Entitlement type and cross verify. There sometimes its an issue with Display Name and Entitlement Name

[afauquem]

Hi @Manu269, @rushikeshvartak, @CR 

Thanks for your responses. It works to import the entitlement values. 

Can you confirm this topic https://forums.saviynt.com/t5/identity-governance/azuread-ootb-lastlogindate/m-p/34521  -> "the lastlogindate value is currently only available as part of the beta api"

If this attribute is available via csv upload, is there a specific date format expected ?

Thanks