/build/static/layout/Breadcrumb_cap_w.png

AD Account Expiry attribute in Kace 1000 Users

We want to bring in the AD Account Expiry attribute into the User section in KACE 1000. While we are able to select the appropriate field in the LDAP User Authentication scheduler, the resulting field's format is a long integer. Is there a way to format this into a proper date?

Is there a SQL query that any one has tried to accomplish something similar to this ? Our end goal is to have current data from Active Directory with account expiry in KACE.

Thanks in advance for the assistance.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: chucksteel 6 years ago
Red Belt
0
You would need to import the LDAP attribute into a custom field and then have another custom field to store the converted time. See this example for a conversion technique:

The second field could be populated using a custom service desk rule that finds entries in the USER_FIELD_VALUE table that aren't set and then queries the imported value and updates accordingly.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ