How to pull AD Filed account expires in sys_user table

[Alex_3]

HI,

The AD attribute Account Expires: accountExpires = contains a number in C# that represents an expiration date/time, would likely need to be converted to Date/Time format. 
number as, tics since 1601-01-02

My goal is when When the LDAP scheduled job is run, expiration date will be populated if the fields have values in AD.

Thanks,

Ruchi

[Aman Kumar S]

Hi @Alex_3 ,

Below article should assist your to achieve this requirement.

https://www.servicenow.com/community/developer-forum/accountexpires-attribute-import-to-user-table/m...

[Alex_3]

Thanks @Aman Kumar S 

My accountExpires filed from AD is in C# and the filed in user table I want to map is Yes/No Filed.

and if accountExpires has value in AD then we want to check the box in sys_user table.