Issue while reconciling the AD lastlogon Attribute into saviynt

[adityachadde]

Hi Team,

We are trying to reconcile the Active directory lastLogon attribute into Saviynt the attribute is getting reconciled, but we are unable to see the exact date in Saviynt. please find the below screenshot and sample users for more information. There is a mismatch in the lastlogon date for some users it is coming as expected but for some users, it is not. 

18-11-2019  18:12:10

sroy.emeat

2020-02-21 09:32:47

ppardhi.emeat

2020-03-06 08:19:54

dgajbhiye.emeat

What could be this issue?

Please help us to resolve this issue.

Best Regards,

Aditya Chadde

[prashantChauhan]

Can you please share the value of ACCOUNT_ATTRIBUTE being used in the connection?

[adityachadde]

Hi

Please find the below details.

[NAME::samaccountname#String,
ACCOUNTID::distinguishedname#String,
LASTLOGONDATE::lastlogon#millisec,
LASTPASSWORDCHANGE::pwdlastset#millisec,
DISPLAYNAME::displayname#String,
CUSTOMPROPERTY1::employeeid#String,
CUSTOMPROPERTY2::mail#String,
CUSTOMPROPERTY3::sn#String,
CUSTOMPROPERTY4::givenname#String,
CUSTOMPROPERTY5::cn#String,
CUSTOMPROPERTY6::userprincipalname#String,
CUSTOMPROPERTY7::useraccountcontrol#number,
CUSTOMPROPERTY8::department#String,
CUSTOMPROPERTY9::title#String,
CUSTOMPROPERTY10::lastlogondate#millisec,
CUSTOMPROPERTY11::co#String,
CUSTOMPROPERTY12::c#String,
CUSTOMPROPERTY13::countrycode#String,
CUSTOMPROPERTY14::employeetype#String,
CUSTOMPROPERTY15::mobile#String,
CUSTOMPROPERTY16::division#String,
CUSTOMPROPERTY17::name#String,
CUSTOMPROPERTY20::manager#String,
CUSTOMPROPERTY26::objectguid#String,
CUSTOMPROPERTY28::company#String,
CUSTOMPROPERTY30::extensionattribute8#String,
CUSTOMPROPERTY19::employeenumber#String,
STATUS::useraccountcontrol#number,
CUSTOMPROPERTY21::homedrive#String,
CUSTOMPROPERTY22::homedirectory#String,
CUSTOMPROPERTY24::msds-cloudextensionattribute5#String,
RECONCILATION_FIELD::CUSTOMPROPERTY26]

Best Regards,

Aditya Chadde

[Nmaheshwari]

Any suggestions here ?

[prashantChauhan]

I tried replicating the issue and I am observing that the Date-Time seen in the AD is in Daylight standard time and the Date-Time saved in Saviynt is in UTC standard time but it is getting saved accurately if I take the time difference into consideration.

Can you please check if that is the case for you as well?