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.
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)
Please log in to answer
Posted by:
chucksteel
7 years ago
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.
