LDAP: accountexpires attribute values

Account expiration in Active Directory is represented by 2 values, accountExpires (ldap attribute) and AccountExpirationDate (ADSI method). The latter does an automatic conversion of the accountExpires attribute for you. The format of accountExpires is integer8 and has to be converted to a readable date/time. The number you see in AD is the number of 100-nanosecond intervals since 12:00 AM January 1, 1601. Possible default values:

Lees meer

SQL: conditional statements in select queries using case

When you need conditional statements in an SQL query, for instance to do some date calculation within the SELECT statement, you can do:

Lees meer

ADSI: error 8250 "the server is not operational"

This error can be generated when the domain controller you use in scripting suffers from sub-optimal performance. In bulk scripts when lots of requests are done on a single domain controller, ADSI can generate this error. If the domain controller you are using is virtualized, try performing the same operation on a physical domain controller.

Lees meer