Saviynt Forums

VamsheeVazza · ‎07/10/2024

Hi,

We have a requirement to collect last logon date from AD into Saviynt through an AD connector.

But the field is in FileTime format. (not unix time)

How can we convert it to human readable date while collecting it into Saviynt.

sudeshjaiswal · ‎07/12/2024

Hello @VamsheeVazza ,

Can you please share the json you have tried.

Thanks.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

Manu269 · ‎07/12/2024

Under Account_Attribute parameter use as below :

LASTLOGONDATE::lastLogon#millisec,

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

VamsheeVazza · ‎07/12/2024

This only works for Unix time not for file time.

rushikeshvartak · ‎07/12/2024

Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Manu269 · ‎07/15/2024

Then the only option I could think of could be enhanced query.

I have not tried it though, please post if that works for this community.

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Convert FileTime to Human readable Date