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

Use Enhanced Query to convert filetime to Human readable format
Share current format received in saviynt

Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

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
.

Saviynt Forums

Convert FileTime to Human readable Date